1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the command for user data type?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is the command for user data type?..

Answer / 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

what is the command for user data type?..

Answer / yadav

mm its also said as abstrract data types

ie which will contain more than one datatype

same as above

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

How many types of normalization are there?

0 Answers  

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

What is database white box testing and black box testing?

0 Answers  

what is meant by nl2br()? : Sql dba

0 Answers  




how to increment dates by 1 in mysql? : Sql dba

0 Answers  

What is compiled query?

0 Answers  

how to retrieve only duplicate values in a table

9 Answers  

What are views in sql?

0 Answers  

What is inner join in sql?

0 Answers  

What are the parts of a basic sql query?

0 Answers  

What are user defined functions?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories