what is the command for user data type?
Answers were Sorted based on User's Feedback
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 |
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 |
How does postgresql compare to oracle/db2/ms sql server/informix?
How does postgresql compare to "nosql"?
Is primary key is clustered index?
What are the disadvantages of not performing database normalization?
How do you write an inner join query?
Why do we create views in sql?
What is natural join in sql?
What is procedure explain with program?
What is offset in sql query?
How do you write an index?
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
What is sql*loader?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)