Answer Posted / ramprasad.s

Hi


Oracle 9i has the advatantage over Partition Table.



bye
sun_ramprasad@yahoo.com

20. Using a set operator, display the client number of all clients who have never placed an order.

2142

---

Explain joins in oracle?

977

---

Is there any function in oracle similar like group_concat of mysql?

985

---

How to do paging with oracle?

948

---

Can you assign multiple query result rows to a variable?

926

---

How can we create the complete backup of data in the oracle.

2089

---

What is a server parameter file in oracle?

1000

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2070

---

How do I escape a reserved word in oracle?

1127

---

How to use attributes of the implicit cursor in oracle?

946

---

What is a synonym? What are its various types?

1042

---

How to assign values to data fields in record variables?

972

---

Differentiate between pre-select and pre-query?

1049

---

How to change user password in oracle?

973

---

How can we find out the duplicate values in an oracle table?

992

---