|
SQL> create type myArrayType
2 as varray(10) of number(12,2)
3 /
Type created.
SQL>
SQL> create table t
2 ( x int primary key, y myArrayType )
3 /
Table created.
SQL>
SQL> drop table t;
Table dropped.
SQL> drop type myArrayType;
Type dropped.
SQL>
SQL>
SQL> –
|
Tags: Code, defined varray type as column type, Object Oriented Database, Object Table, Object Table laquo Object Oriented Database laquo Oracle PL SQL, Oracle PL / SQL, Use user
Posted in Uncategorized |
This entry was posted
on Saturday, June 27th, 2009 at 7:15 pm and is filed under Uncategorized.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
