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