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
9021 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 the limitations of sql express?

1114

What is cursor and why it is required?

1247

What are system versioned tables?

1066

What is on delete set null?

1132

How to select 10 records from a table?

1201

what is the difference between union and union all? : Sql dba

1060

What is a left join?

1003

define data blocks ? : Sql dba

1040

Why functions are used in sql?

1038

What is the difference between sum and count in sql?

1029

What are the two types of periodical indexes?

985

What is denormalization in a database?

1103

How do I run a program in pl sql?

1050

What are field types?

1048

What is the most restrictive isolation level? : Transact sql

1121