Interested to Buy Any Domain ? << Click Here >> for more details...
how can i create a user defined datatype
- 3 Answers
- 7404 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mv
we can create a user defined data type by using subtype.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vetrikumaran
WE CAN CREATE A USER DEFINED DATATYPE BY USING RECORD DATATYPE..
RECORD,INDEX BY TABLE ARE NOT BUT USER DEFINED DATATYPES
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / avi007
We can create a user defind datatype by using abtract
datatype.
create type address_type as object
( street varchar2(10),
pincode number(6);
);
This is used in
create table emp
(Empname varchar2(20),
Adress address_type);
// address_type is user defined datatype
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the usage of sql functions?
How do you use join?
Explain the the update statement in sql?
Define commit?
How can I tell if sql is running?
Why do we use procedures in sql?
Can we use rowid as primary key?
What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN
what is the difference between the query and corelated query
8 Answers HSBC, IBM, TCS, Xenosoft,
What is rowtype?
how can we know the number of days between two given dates using mysql? : Sql dba
Can we write ddl statements in functions?
-
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)
