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 |
i want to display 1 to 10 numbers using one select statement.
18 Answers HCL, Nyros, Oracle,
i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent
What is db journal file?
What is the diff between Truncate table / delete <table name> purge
Does db2 use sql?
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification
Compare sql & pl/sql
How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar
How do you declare a user-defined exception?
How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)
Explain what is an index?
what are the advantages of using stored procedures? : Sql dba
Oracle (3253)
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)