15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2252

---

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

2149

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2057

---

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1963

---

What are the consideration at tehe migration of Oracle 9i to 10G.

3017

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2197

---

What is the exact use of Collections?

2104

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5348

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2913

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2141

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2429

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2017

---

can u plz provide me oca sql dumps please i need them

1909

---

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4399

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1958

---