create table based on a user defined type
Posted
by Glen
on Stack Overflow
See other posts from Stack Overflow
or by Glen
Published on 2010-03-12T11:24:37Z
Indexed on
2010/03/12
11:27 UTC
Read the original article
Hit count: 367
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)
);
© Stack Overflow or respective owner