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 is exception handling handled in mysql? : Sql dba
How do you optimize a query?
What is the difference between between and in condition operators?
Is nosql faster than sql?
What is the difference between numeric and autonumber?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
Why do we use view in sql?
What are operators available in sql?
What is the current version of postgresql?
Explain the update statement in sql
What is compiled query?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
what are numeric data types? : Sql dba
What are the benefits of pl sql?
What is primary and foreign key?
