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

what are tables and fields? : Sql dba

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

What is sql and how does it work?

0 Answers  

---

I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  

---

What is lookup table in sql?

0 Answers  

---

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

How can I get the number of records affected by a stored procedure?

0 Answers  

---

How can you know that statistics should be updated?

0 Answers  

---

What are different types of tables in sql?

0 Answers  

---

What is a boolean in sql?

0 Answers  

---

Is left join faster than join?

0 Answers  

---

what is user defined functions? : Sql dba

0 Answers  

---