Answer / orawhiz

A Public synonyms can be accessed by any user on the database

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---

How to define an anonymous procedure with variables?

0 Answers  

---

How a database is related to tablespaces?

0 Answers  

---

What do you mean by merge in oracle and how can you merge two tables?

0 Answers  

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

---

How to use subqueries with the in operator using oracle?

0 Answers  

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,

---

12. Display the client name in upper case only and in lower case only.

1 Answers   Wipro,

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

How to recover a dropped table in oracle?

0 Answers  

---

How to call a stored function in oracle?

0 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---