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 the types of views in sql?

0 Answers  

---

How many databases can sql express handle?

0 Answers  

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

What are the main features of cursor?

0 Answers  

---

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

Describe types of sql statements?

0 Answers  

---

how to shutdown mysql server? : Sql dba

0 Answers  

---

What are all the common sql functions?

0 Answers  

---

how to use like conditions? : Sql dba

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

What jobs use sql?

0 Answers  

---