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
how to use myisamchk to check or repair myisam tables? : Sql dba
What is the difference between microsoft sql and mysql?
What is the use of index in hive?
Can a key be both primary and foreign?
How do you determine the current isolation level? : Transact sql
How do you run a query?
Where do we use pl sql?
What are field types?
Why is stored procedure faster than query?
What are the parts of a basic sql query?
Why partition by is used in sql?
What is cartesian join in sql?
what is a foreign key ? : Sql dba
What is sql query optimization?
What are the different dml commands in sql?
