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
9033 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 is the difference between distinct and unique in sql?

991

Why indexing is needed?

1044

Which data type is a composite type?

1036

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1272

What is the usage of when clause in trigger?

1088

what are all the different normalizations? : Sql dba

1118

What found sql?

995

How do I tune a sql query?

1040

What is structural independence and why is it important?

1074

What is the difference between drop and truncate commands?

1110

What is the usage of distinct keyword?

1113

How do you update f as m and m as f from the below table testtable?

1930

What are the datatypes available in pl/sql ?

1151

What are the different types of tables in sql?

1063

how to get a list of indexes of an existing table? : Sql dba

1005