Hi, What is nocopy parameter in oracle procedure. what is the use of it. In which situation,we can use the nocopy parameter.Thanks,Saravanan.P
Latest Answer: TO PASS OUT AND INOUT Parameters by refrenece instead of value. ...
Hi, can any body give me the sample program for avoiding the mutating error. we can avoid the mutating through the statement level trigger instead of using the statement leve trigger, i need one sample
Latest Answer: A mutating error comes when u r trying to do some DML operation on a table that owns the trigger.... there are a lot of options to avoid mutation .. eg, Making it autonomous transaction or making it a statement level trigger ... or using ...
Latest Answer: PL/SQL tables are temporary array like objects used in a PL/SQL Block. The size of pl/sql table is unconstrained. For varrays we need to specify upperbound.Pl/sql tables can not be stored in database where as varrays can be stored in database.We can use ...
Latest Answer: Pls try this link:http://www.databasejournal.com/features/oracle/article.php/1558021Cheers- Faizal ...
Latest Answer: Disadvantage : 1) Executing DDL statements through dbms_sql sometime can result in deadlock. example : we are trying to drop one object at the time it is being accessed by other user. ...
Latest Answer: By using pragma_restrict_references we can give the different status to functions,Like WNDB(WRITE NO DATA BASE),RNDB(read no data base),Write no package state,read no packge state.W ...
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. ...
View page << Previous 4 5 6 7 [8] 9 10 11 12 13 Next >>
Go Top
