rowtype and type : Type « PL SQL « Oracle 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>

   
    
  








Related examples in the same category

1.Declare scalars based on the datatype of a previously declared variable
2.Select only one row for column type variable
3.Creating a procedure and call it
4.Passing %TYPE and %ROWTYPE as Parameters
5.Column%type parameter
6.reference table data with tableName.columnName%type
7.Add row to table with tableName.columnName%type