Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Rowtype and type

SQL> SQL> CREATE TABLE departments   2  (department_id           number(10)            not null,   3   department_name      varchar2(50)      not null,   4   CONSTRAINT departments_pk PRIMARY KEY (department_id)   5  ); Table created. SQL> SQL> SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 1,             'Data Group' ); 1 row created. SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 2,             'Purchasing' ); 1 row created. SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 3,             'Call Center' ); 1 row created. SQL> SQL> insert into departments ( department_id, department_name )   2                    values( 4,             'Communication' ); 1 row created. SQL> SQL> SQL>  set serverout on SQL> SQL>  declare   2      l_dept         departments%rowtype;   3      l_another_dept departments.department_name%type;   4    begin   5      l_dept.department_id := 1000;   6      l_dept.department_name := 'Graphic Art';   7   8      insert into departments(   9        department_id, department_name)  10      values(  11        l_dept.department_id, l_dept.department_name);  12  13      l_dept.department_id := 1001;  14      l_another_dept := 'Web Design/User Interface';  15  16      insert into departments(  17        department_id, department_name)  18      values(  19        l_dept.department_id, l_another_dept);  20  21      dbms_output.put_line('The departments created were ' ||  22        l_dept.department_name || ' and ' || l_another_dept);  23    end;  24    / The departments created were Graphic Art and Web Design/User Interface PL/SQL procedure successfully completed. SQL> SQL> drop table departments; Table dropped. SQL>