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 19 null in sql?

547


What is pl sql quora?

657


What is user defined functions?

588


what is a trigger in mysql? : Sql dba

613


What is the difference between nvl function, ifnull function, and isnull function?

607






What is sql catalog?

580


Why is theta join required?

675


What is pessimistic concurrency control? : Transact sql

597


Is sql scripting language?

535


Is sql developer case sensitive?

534


How can you save or place your msg in a table?

533


Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

540


Is merge a dml statement?

532


What is mutating error in pl sql?

561


What found sql?

534