Anonymous PL/SQL Block Structure: [DECLARE] BEGIN –statements [EXCEPTION] END; Example: set...
Author - shohal
What is procedure and function in PL SQL?
Procedure and Function in PL SQL “A procedures or function is a group or set of SQL and...
What is PL/SQL Block
PL/SQL Block Program written in PL/SQL language as divided into blocks.Block are basic programming...
Language
Language Here you Can find Oracle, SQL,PL/SQL,ASP.NET Programming Languages.
SQL Server Interview Questions on Indexes – Part 2
SQL Server Interview Questions What are the disadvantages of an Index? There are 2 disadvantages of...
SQL Server Interview Questions on Indexes – Part 1
SQL Server Interview Questions What is the use of an Index in SQL Server? Relational databases like...
Built in string functions in sql server 2008
Built in string functions in sql server 2008 Functions in SQL server can be broadly divided into 2...
Basic SQL Server Interview Questions
Basic SQL Server Interview Questions Explain DML, DDL, DCL and TCL statements with examples? DML:...
What is sp_depends in SQL Server?
What is sp_depends in SQL Server? sp_depends is a system stored procedure that displays information...
Replicate, Space, Patindex, Replace and Stuff functions
Replicate REPLICATE(String_To_Be_Replicated, Number_Of_Times_To_Replicate) – Repeats the...