Tag Archives: PL/SQL Character Set

PL/SQL block

PL/SQL Block Structure PL/SQL block : PL/SQL is a block-structured language. A PL/SQL block defines a unit of processing, which can include its own local variables, SQL statements,cursors, and exception handlers. The blocks can be nested. The simplest block structure is given below: DECLARE Variable declarations BEGIN Program statements EXCEPTION WHEN exception THEN Program Statements END; In …