can we declare a column having number data type and its scale is larger than pricesion ex: column_name NUMBER(10,100), column_name NUMBAER(10,-84)

Explain the usage of WHERE CURRENT OF clause in cursors ?

Name the tables where characteristics of Package, procedure and functions are stored ?

Explain the two type of Cursors ?

What are two parts of package ?

What are two virtual tables available during database trigger execution ?

What is Overloading of procedures ?

What is Pragma EXECPTION_INIT ? Explain the usage ?

What is difference b/w stored procedures and application procedures,stored function and application function..

What are the return values of functions SQLCODE and SQLERRM ?

What are the datatypes a available in PL/SQL ?

Explian rowid,rownum?what are the psoducolumns we have?

What is Raise_application_error ?

What are the two parts of a procedure ?

Give the structure of the procedure ?

What is the basic structure of PL/SQL ?

What is PL/SQL ?

1)what is the starting "oracle error number"? 2)what is meant by forward declaration in functions?

What is PL/SQL table ?

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

How many types of database triggers can be specified on a table ? What are they ?

What are the modes of parameters that can be passed to a procedure ?

Where the Pre_defined_exceptions are stored ?

State the difference between implict and explict cursor's

Write the order of precedence for validation of a column in a table ? I. done using Database triggers. ii. done using Integarity Constraints.

Give the structure of the function ?

Explain how procedures and functions are called in a PL/SQL block ?

What are advantages fo Stored Procedures

What is an Exception ? What are types of Exception ?

What are the PL/SQL Statements used in cursor processing ?

What are the components of a PL/SQL Block ?

What is a database trigger ? Name some usages of database trigger ?

What is a cursor ? Why Cursor is required ?

What is a cursor for loop ?

What will happen after commit statement ?

What are the Restrictions on Cursor Variables?

How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...

What will the Output for this Coding> Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype; Begin Open C1; Fetch c1 into Z; Commit; Fetch c1 in to Z; end;


In a Distributed Database System Can we execu...

Show full text: 3,827 characters