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

2290

---

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

2180

---

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.

2095

---

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

2016

---

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

3051

---

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

2230

---

What is the exact use of Collections?

2140

---

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

5406

---

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

2966

---

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

2180

---

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 ?

2464

---

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....

2057

---

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

1943

---

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

4440

---

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?

2004

---