Answer Posted / madhavi
The main advantage of package is one time compilation
process.while the first time of compilation the source code
is converted into P-code and stored in the database so that
for n no of time calling the pckg it does not take any
memory locations...
*Then whatevere the database objects declared in the
package specification will be globally accessible.
| Is This Answer Correct ? | 18 Yes | 5 No |
Post New Answer View All Answers
What found sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
How can I speed up sql query?
What is a procedure in pl sql?
How does join work in sql?
Can we rename a column in the output of sql query?
Explain 3 basic parts of a trigger.
What sql does db2 use?
how to use like conditions? : Sql dba
what is sql? : Sql dba
which types of join is used in sql widely? : Sql dba
What does fetching a cursor do?
Is primary key a clustered index?
how to show all tables with 'mysql'? : Sql dba
What are the operators in sql?
