4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
- 1 Answers
- 3985 Views
- Wipro, I also Faced
- E-Mail Answers
select 'Client '|| nvl (to_char(client_no),'unknown') ||'
has placed order to the value of '|| nvl(sum(order_no),0)
order_summary
from order
group by client_no
OUTPUT...
ORDER_SUMMARY
---------------------------------------------------
Client unknown has placed order to the value of 200
Client 1006 has placed order to the value of 4
Client 1008 has placed order to the value of 0
Client 1004 has placed order to the value of 54
Client 1005 has placed order to the value of 450
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain the difference between sap and oracle?
How to drop an existing table in oracle?
What is a connect identifier?
Give the constructs of a package, function or a procedure.
 How to use an oracle sequence generator in a mapping?
What is open database communication (odbc) in oracle?
Can we protect our pl/sql source code?
Explain overloading. Can functions be overloaded?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
What is a Data File ?
when loggined as SYSTEM,how to display all the users of database using sql query?
WHAT IS ecc 6.0
Oracle General 
