Home » SQL & PL/SQL » SQL & PL/SQL » Re: PL/SQL Program Constructs
Re: PL/SQL Program Constructs [message #20585] Wed, 05 June 2002 21:43
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
Previous Topic: HOW TO QUERY LOBS
Next Topic: Re: Verifying if the data(one row) fulfilling a select criteria exists in the table or not
Goto Forum:
  


Current Time: Mon Nov 12 16:10:09 CST 2018