Insert table%rowtype to table : rowtype « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. rowtype

Insert table%rowtype to table

 
SQL> create table T (
  2   c1 number,
  3   c2 number );

Table created.

SQL>
SQL>
SQL> insert into T values (1,2);

1 row created.

SQL>
SQL>
SQL> create table myTable1 as select * from T;



SQL>
SQL>
SQL> create or replace procedure WITH_ROWTYPE is
  2       r T%ROWTYPE;
  3   begin
  4       select * into r from T where rownum = 1;
  5       insert into myTable1 values (r.c1, r.c2);
  6   end;
  7  /








Related examples in the same category

1.Use select command to fill value to rowtype variable
2.Define row type variable
3.Define rowtype and reference its column value
4.rowtype index by binary_integer
5.Use rowtype type value to query a table
6.Cursor and rowtype
7.For each row in the cursor
8.From Fields to Rows-Using %ROWTYPE
9.Rowtype variable
10.Select * into table%rowtype
11.Select data into rowtype variable
12.fetch sys_refcursor type variable to table%rowtype variable