Latest Answer: Pragma RESTRICT_REFERENCES is a compiler directive.It makes sure that the function maintains the purity rules and code in fuction creation satisfy the purity rules.There are 4 values for it.WNDS,RNDS,WNPS,RNPS.ThanksJai Sainath ...
In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW . To do you avoid these execeptions. How do you write SQL statement in alternative way?
Without closing the cursor, If you want to open it what will happen. If error, get what is the error?
In function and procedure the parameter pass is "call by value" or "call by reference"?
Latest Answer: by using show_errors we can see the errors in the prev created procedure. dbms_output.put_line. ...
Latest Answer: one thing nikhil handle sqlerrm with variables .that increases perfmance ok. ...
Select from A table through cursor and update B table. If it updates successfully then insert into another table.
Handled every type of exception in the code?
Latest Answer: yes its possible. ...
Latest Answer: Rank Function can cause non-consecutive rankings if the tested values are the same. Whereas, the dense_rank function will always result in consecutive rankings. ...
Latest Answer: A strong REF CURSOR type definition specifies a return type, but a weak definition does not.DECLARE TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; -- strong ...
View page << Previous 5 6 7 8 [9] 10 11 12 13 14 Next >>
Go Top
