开发者

create table based on a user defined type

开发者 https://www.devze.com 2022-12-22 22:23 出处:网络
Suppose I have a user defined type: CREATE OR REPLACE TYPE TEST_TYPE AS OBJECT ( f1 varchar2(10), f2 number(5)

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;
0

精彩评论

暂无评论...
验证码 换一张
取 消