Answer Posted / santanu
NO COPY is compiler hint that process at run time not
compile time. this clause are use for pass the actual out
or in out parameter value as a call by referance insted of
call by value. call by value (mode out/inout) are copy the
value of actual parameter to the formal parameter if the
passing value is a large object it will take vary large
memory and it effect the performence.
create procedule (x in varchar2,y out nocopy varchar2)
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Can we insert delete data in view?
What is right join sql?
What are different types of sql commands?
How to return an array from java to pl/sql?
What is sql server and ase?
What are crud methods?
What is scope and visibility in PL/SQL?
Can we group by two columns in sql?
Is sqlite good enough for production?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is a sql instance vs database?
How can you create an empty table from an existing table?
What is clause in sql?
Do stored procedures prevent sql injection?
Mention what are the benefits of pl/sql packages?
