create table based on a user defined type
Suppose I have a user defined type:
CREATE OR REPLACE TYPE TEST_TYPE AS OBJECT
(
f1 varchar2(10),
f2 number(5)
);
Now, I want to create a table to hold these types. I can do the following:
create table test_type_table (
test_type_field test_type
);
This gives me a table with one column, test_type_field
.
Is there an easy and automated 开发者_开发技巧way to instead create a table such that it has 2 columns, f1
and f2
?. So that it's the equivilent to writing:
create table test_type_table (
f1 varchar2(10),
f2 number(5)
);
Have you tried:
create table test_type_table of test_type;
精彩评论