what is the command for user data type?

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 difference between function and trigger?

540


how does a local variable is defined using t-sql? : Transact sql

537


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

500


define sql delete statement ? : Sql dba

553


How is use pl and sql?

547






How do I sort a table in sql?

587


Is truncate ddl or dml?

539


how to create a new view in mysql? : Sql dba

490


what is auto increment? : Sql dba

565


Is sql an operating system?

543


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3193


Are left and right joins the same?

526


What is a rank in sql?

534


how to shut down the server with 'mysqladmin'? : Sql dba

539


What is graph sql?

522