Answer Posted / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

What are all different types of collation sensitivity?

735

---

What are the disadvantages of file system?

819

---

What is data control language (dcl)?

787

---

Explain ddl statements in pl/sql?

734

---

What are hotfixes and patches?

689

---

---

What do you mean by rowid?

702

---

What is the difference between database trigger and stored procedure?

738

---

Enlist some predefined exceptions?

795

---

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

800

---

What is server name sql?

799

---

Is it possible to create the following trigger: before or after update trigger for each row?

914

---

What is a nested table in word?

703

---

Why do we need view in sql?

728

---

What is difference between mysql and postgresql?

703

---

How many types of literals are available in pl sql?

748

---