Re: user defined data type
From: Jova <jovaughnl_at_yahoo.com>
Date: Wed, 26 Sep 2001 17:33:27 GMT
Message-ID: <Hjos7.10773$w7.2392904_at_news02.optonline.net>
Date: Wed, 26 Sep 2001 17:33:27 GMT
Message-ID: <Hjos7.10773$w7.2392904_at_news02.optonline.net>
there are 2 that I know of table and record
declare
TYPE record_name IS Record (
field1 type1 [NOT NULL] [:=expr1], field2 type2 [NOT NULL [:=expr2], ... fieldn typen [NOT NULL] [:=exprn]);
for the tables
TYPE tablename IS TABLE of type INDEX by BINARY_INTEGER;
"bao" <chong_at_hq.psa.com.sg> wrote in message
news:fcc16b79.0109260131.7e2068b_at_posting.google.com...
> Can we create user defined data type in Oracle? How?
Received on Wed Sep 26 2001 - 19:33:27 CEST