What is sql catalog?

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

What is a call statement? Explain with an example.

0 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

What is oracle sql called?

0 Answers  

---

---

discuss about myisam index statistics collection. : Sql dba

0 Answers  

---

what is the difference between union and union all? : Sql dba

0 Answers  

---

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

What are the data types allowed in a table?

3 Answers  

---

what are the properties and different types of sub-queries? : Sql dba

0 Answers  

---

What is rename command in sql?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---