Building Blocks of PL/SQL : Begin End Block « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Begin End Block

Building Blocks of PL/SQL

  
SQL>
SQL> set serveroutput on;
SQL>
SQL> CREATE TABLE items_tab (item_code varchar2(6) PRIMARY KEY,
  2                          item_descr varchar2(20) NOT NULL);

Table created.

SQL>
SQL>
SQL>
SQL> DECLARE
  2       v_item_code VARCHAR2(6);
  3       v_item_descr VARCHAR2(20);
  4  BEGIN
  5       v_item_code := 'ITM101';
  6       v_item_descr := 'Spare parts';
  7       INSERT INTO items_tab VALUES (v_item_code, v_item_descr);
  8  EXCEPTION WHEN OTHERS THEN
  9       dbms_output.put_line(SQLERRM);
 10  END;
 11  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from items_tab;
ITEM_C ITEM_DESCR
------ --------------------
ITM101 Spare parts

1 row selected.

SQL>
SQL> drop table items_tab;

Table dropped.

SQL>
SQL> --

   
  

Related examples in the same category