PL/SQL Programming

Writing the first stored procedure

Create or Replace procedure  is begin  Insert  into Values ('n ','zydev');   End ;   /

viewing errors

Show Error

Executing stored procedures

exec procedure_name (value1,value2); call Procedure_name (value1,value2);

Writing specifications

Single-line Comment-    Multiline comment      / *.... */ Define variables    v_name Define constants    C_name define Cursors   name_cursor definition exceptions   e_name

The PL/SQL block consists of the definition section (declear), the execution part (begin), the Exception Handling section (exception), and three parts

The simplest piece of a block

SQL>seton;     --Open Output options sql>begin  2  dbms_output.put_line ('Hello, World!!!! ' );   3  End ;   4  /

PL/SQL Programming