Answer / mv

we can create a user defined data type by using subtype.

Answer / vetrikumaran

WE CAN CREATE A USER DEFINED DATATYPE BY USING RECORD DATATYPE..

RECORD,INDEX BY TABLE ARE NOT BUT USER DEFINED DATATYPES

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 keyword pl sql?

0 Answers  

---

What are the usages of sql?

0 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

what is sql in mysql? : Sql dba

0 Answers  

---

Which join condition can be specified using on clause?

0 Answers  

---

---

How to use distinct and count in sql query? Explain

0 Answers  

---

How many indexes can be created on a table in sql?

0 Answers  

---

What is the difference between left outer join and left join?

0 Answers  

---

What is a data manipulation language?

0 Answers  

---

What is compute?

0 Answers  

---

What are the types of join and explain each?

0 Answers  

---

Can one improve the performance of sql*loader? : aql loader

0 Answers  

---