Create table based on single data type : Object Table « Object Oriented Database « Oracle PL / SQL

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

Create table based on single data type

   

SQL> create table myTable of xmltype;

Table created.

SQL>
SQL> insert into myTable values(XMLTYPE('
  2    <customer>
  3     <name>name value</name>
  4     <telephone>123 555-1234</telephone>
  5    </customer>'))
  6  /

1 row created.

SQL>
SQL> select * from myTable;



SYS_NC_ROWINFO$
------------------------------------------------------

  <customer>
   <name>name value</name>
   <telephone>123 555-1234</telephone>

1 row selected.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

   
    
    
  

Related examples in the same category