Organizational Research By

Surprising Reserch Topic questions - 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

Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.