User defined datatype are nothing but TYPE objects e.g. CREATE OR REPLA

what is the command for user data type?

Question Posted / ajexpert

2 Answers
8824 Views
I also Faced
E-Mail Answers

Answer Posted / ajexpert

User defined datatype are nothing but TYPE objects

e.g.
CREATE OR REPLACE TYPE NAME_T AS OBJECT ( COL VARCHAR2
(30))

For more explanation,
Please visit
http://www.databasedesign-resource.com/user-defined-
types.html

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are all types of user defined functions? : Sql dba

1006

What is trigger point?

956

what are the advantages and disadvantages of views in a database? : Sql dba

1004

Is subquery faster than join?

965

What is the location of pre_defined_functions.

1121

How long will it take to learn pl sql?

897

What is crud stand for?

944

How do sql triggers work?

993

What is the meaning of disabling a trigger?

1120

What is database sql?

999

How many clustered indexes can you have?

932

what are the t string functions available in tsql? : Transact sql

953

what is column? : Sql dba

966

What is pragma in sql?

1032

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

954