Re: PL/SQL Program Constructs [message #20587] |
Wed, 05 June 2002 21:46 |
manish mendiratta
Messages: 110 Registered: May 2002
|
Senior Member |
|
|
Understand the basic diff between them. You can broadly classify them in anonymous and named pl/sql blocks.
Anonymous blocks are not stored in database. They donot start with create statement.
They are complied and executed the very moment their code is executed. However, triggers , functions and procedures,packages. codes are stored in database as pcode. They are not compiled when they are called as their complied code is stored in DB.You can look for them in oracle documentation and any good book on PL/SQL
|
|
|