Where the Pre_defined_exceptions are stored ?
What are the Restrictions on Cursor Variables?
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;
What is the starting "oracle error number"? 2)What is meant by forward declaration in functions?
What is ref cursor?
What are two virtual tables available during database trigger execution ?
What is difference between % ROWTYPE and TYPE RECORD ?
What is pl/sql?what are the advantages of pl/sql?
What is a database trigger ? Name some usages of database trigger ?
What will happen after commit statement ?
What is PL/SQL ?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
What are two parts of package ?
What is a cursor for loop ?
What are the modes of parameters that can be passed to a procedure ?
What is Pragma EXECPTION_INIT ? Explain the usage ?
What is the basic structure of PL/SQL ?
What is a stored procedure ?
Next>>
