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
How do I start sql from command line?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is multiple columns?
Can you have more than one trigger on a table?
What can you do with pl sql?
Explain what is a column in a table?
What is pl sql in dbms?
Why is partition used in sql?
What is data manipulation language?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
is it possible to pass an object or table to a procedure as an argument?
Can procedure in package be overloaded?
What's the difference between inner join and left join?
What is the use of stored procedures?
What does joining a thread mean?
