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 a trigger in mysql? Define different types of trigger. : Sql dba

0 Answers  

---

Where do we use pl sql?

0 Answers  

---

What is a dynamic query?

0 Answers  

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

What are the usage of SAVEPOINTS?

5 Answers  

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

what are the nonstandard string types? : Sql dba

0 Answers  

---

How do you change a value in sql?

0 Answers  

---

Is sql a case sensitive language?

0 Answers  

---

what is Complex index. how to create it?

2 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---