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 is the example of procedure?

0 Answers  

---

what is the use of double ampersand (&&) in sql queries?

0 Answers  

---

What is difference between inner join and cross join?

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

How can you fetch first 5 characters of the string?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

What is record in pl sql?

0 Answers  

---

Can I call a procedure inside a function?

0 Answers  

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---

What are the different types of joins and explain them briefly.

3 Answers  

---

What is an Integrity Constraint?

4 Answers  

---

What is the benefit of foreign key?

0 Answers  

---