Insert value with type variable : Insert « Object Oriented Database « Oracle PL / SQL

1. Oracle PL / SQL
2. Object Oriented Database
3. Insert

Insert value with type variable

 
SQL>
SQL>
SQL> create or replace
  2  type person as object(
  3   first_name varchar2(100),
  4   last_name varchar2(100) )
  5  /

Type created.

SQL>
SQL>
SQL> create table person_table( p person );

Table created.

SQL>
SQL>
SQL> declare
  2   l_person person;
  3  begin
  4   l_person := person( 'C', 'B' );
  5   insert into person_table
  6   values ( l_person );
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL> select * from person_table;


P(FIRST_NAME, LAST_NAME)
--------------------------------------------------------------------------------
PERSON('C', 'B')

SQL>
SQL> drop table person_table;

Table dropped.

SQL>
SQL>

 

Related examples in the same category