Dec
13

Structure of PL/SQL Block

By admin  //  Oracle  //  View Comments

[<Block Header>]

[DECLARE

<constants>

<variables>

<Cursors>

<user defined exceptions>

]

BEGIN

<PL/SQL Statements>

[Exceptions <exception handlings>]

END;

BLOCK HEADER specifies whether the PL/SQL block is procedure, a function or a package. If no header is specified, the block is said to be an anonymous PL/SQL block.

Related posts:

  1. Procedure in PL/SQL
  2. Function in PL/SQL
  3. Trigger in PL/SQL
  4. Writing SQL Statements
blog comments powered by Disqus

Namaste!

Hello! This is Nirmal Gyanwali, a freelance web developer from Kathmandu, Nepal. I am well versed with Open source CMS and portal frameworks like Joomla!, Wordpress, Drupal. If you're interested, you can contact me at info@nirmal.com.np.
Thanks!

Latest Tweets