Organizational Research By

Surprising Reserch Topic

Question:What is the difference between anonymous blocks and stored procedures ?


  1. Anonymous block is compiled only when called.
  2. - Stored procedure is compiled and stored in database with the dependency information as well.
  3. - Former is PL/SQL code directly called from an application. Latter is stored in database.
  4. - Former has declare statement.Latter doesnt.
asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes
23 views



Related Hot Questions



Government Jobs Opening


...