Answer / Praveen Shrivastava

Composite data types in PL/SQL are user-defined structures that contain multiple components of different data types. Examples include records, arrays, and nested tables.

Where is sql database stored?

1 Answers  

---

List and explain the different types of join clauses supported in ansi-standard sql?

1 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

What are the types of triggers in sql?

1 Answers  

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

---

what is External tables? explain with examples

2 Answers   TCS,

---

What are the various levels of constraints?

1 Answers  

---

How do I know if I have sql express or standard?

1 Answers  

---

Why truncate is used in sql?

1 Answers  

---