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

Answer / yadav

mm its also said as abstrract data types

ie which will contain more than one datatype

same as above

What is normalisation in sql?

0 Answers  

---

what is offset-fetch filter in tsql? : Transact sql

0 Answers  

---

When is the explicit cursor used ?

0 Answers  

---

How to get the procedure's, function's name from a package if it is wrapped(both spec & body).

2 Answers  

---

How do you create a db file?

0 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

What is varchar sql?

0 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

What are different types of statements supported by sql?

0 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

What are analytical functions in sql?

0 Answers  

---