Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is sqlservr exe?
what happens if you no create privilege in a database? : Sql dba
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How are functions and procedures called in PL/SQL?
What is sap sql anywhere?
What are the different operators available in sql?
What are inner and outer joins examples of both?
How to get unique records from a table?
What is loop in pl sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
How to disable a trigger name update_salary?
Why we use join in sql?
Can we call procedure in select statement?
Differentiate between % rowtype and type record.
How do I start pl sql?
