Answer Posted / ajexpert

User defined datatype are nothing but TYPE objects

e.g.
CREATE OR REPLACE TYPE NAME_T AS OBJECT ( COL VARCHAR2
(30))

For more explanation,
Please visit
http://www.databasedesign-resource.com/user-defined-
types.html

What is anonymous block in sql?

1114

---

What is the primary key?

945

---

Is inner join faster than left join?

1182

---

Can a table contain multiple primary key’s?

1092

---

What are the query optimization techniques?

927

---

Can we commit inside a trigger?

985

---

What is the current version of sql?

1017

---

Can we join more than 2 tables in sql?

1011

---

How can I make sql query run faster?

1006

---

Explain two easy sql optimizations.

1004

---

What is the difference between functions, procedures, and packages in pl/sql?

1037

---

What is oracle pl sql developer?

975

---

What is a join?

1054

---

How to create your own reports in sql developer?

1009

---

What is an inconsistent dependency?

1043

---