PL/SQL

What is PL/SQL

What is PL/SQL ?
Full details

What is the basic structure of PL/SQL

What is the basic structure of PL/SQL ?...
Full details

What is Direct method of testing ?

What is Direct method of testing ?...
Full details

How many types of database triggers

How many types of database triggers can be specified ...
Full details

What are two virtual tables available

What are two virtual tables available during database ...
Full details

Where the Pre_defined_exceptions

Where the Pre_defined_exceptions are stored ?...
Full details

What is Pragma EXCEPTION_INIT ?

What is Pragma EXCEPTION_INIT ?...
Full details

How procedures and functions

How procedures and functions are called in a PL/SQL ...
Full details

What is Raise_application_error

What is Raise_application_error ?...
Full details

Write the order of precedence for validation

Write the order of precedence for validation of a column...
Full details

What are % TYPE and % ROWTYPE ?

What are % TYPE and % ROWTYPE ? ...
Full details

What are the data types a available in PL/SQL

What are the data types a available in PL/SQL ?...
Full details

What is a cursor

What is a cursor ? ...
Full details

What are the cursor attributes

What are the cursor attributes used ...
Full details

What is PL/SQL table ?

What is PL/SQL table ?...
Full details

What are the components of a PL/SQL block

What are the components of a PL/SQL block...
Full details

Why Cursor is required ?

Why Cursor is required ?...
Full details

What is an Exception

What is an Exception ? ...
Full details

What is a database trigger ?

What is a database trigger ?...
Full details

What are the PL/SQL Statements

What are the PL/SQL Statements used ...
Full details

What is difference between % ROWTYPE

What is difference between % ROWTYPE and TYPE RECORD ?...
Full details

What is a cursor for loop

What is a cursor for loop ?...
Full details

What are types of Exception ?

What are types of Exception ?...
Full details

What are advantages of Stored Procedures

What are advantages of Stored Procedures ...
Full details

What is Overloading of procedures

What is Overloading of procedures ?...
Full details

Give the structure of the procedure ?

Give the structure of the procedure ?...
Full details

What are the return values of functions

What are the return values of functions SQLCODE a ...
Full details

What is a package

What is a package ? ...
Full details

What are the two parts of a procedure

What are the two parts of a procedure ?...
Full details

What are the advantages of packages

What are the advantages of packages ?...
Full details

Give the structure of the function ?

Give the structure of the function ?...
Full details

What is a stored procedure

What is a stored procedure ?...
Full details

What are advantages of Stored

What are advantages of Stored Procedures ...
Full details
Log in
Popular tags