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
differentiate between float and double. : Sql dba
Are sql connections encrypted?
What are the indexing methods?
how to drop an existing table in mysql? : Sql dba
What is bind reference and how can it be created?
What is the difference between inner join and left join?
How do I run a sql query?
What is varchar example?
What are the different types of constraints?
What is an alias command?
Can we use ddl statements in stored procedure?
What is a file delimiter?
What is sql query limit?
What does varchar include?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
