Answer Posted / 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

How do I remove sql plus from windows 10?

1088

---

what is acid property in database? : Sql dba

1020

---

What pl/sql package consists of?

1074

---

Can you have more than one trigger on a table?

996

---

What is a field in a database?

1059

---

How does postgresql compare to "nosql"?

1028

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

988

---

What are the 3 types of behavioral triggers?

1244

---

how many values can the set function of mysql take? : Sql dba

981

---

how to write date and time literals? : Sql dba

956

---

Explain polymorphism in pl/sql.

1111

---

What is a delimiter in sas?

1045

---

How do I pipe the output of one isql to another?

1000

---

What is sql deadlock?

1127

---

What is range partitioning?

957

---