18. Display the clientno and total value for all orders
placed by that client. Output the result in the following
format: Client <clientno> has placed orders to the value of
<total value>
- 2 Answers
- 4701 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / girija.112
i forgot to login thats why i have posted it once again
ANS:
select 'Client '||nvl(tochar(client_no,'unknown') ||' has
placed orders to the value of '|| nvl(sum(orders),0) as
order_summary
from order_table
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 | 0 No |
Answer / guest
ANS:
select 'Client '||nvl(tochar(client_no,'unknown') ||' has
placed orders to the value of '|| nvl(sum(orders),0) as
order_summary
from order_table
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 ? | 0 Yes | 1 No |
How to delete multiple rows from a table in oracle?
what is null value?
How to call a stored procedure inside a trigger? Give an example.
How do I spool to a csv formatted file using sqlplus?
Who i will insert 1 lacks record in a Database table
How to define a data field as not null?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
What are the set operators union, union all, minus & intersect meant to do?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Explain what are clusters?
What is redo log?
Why does for update in oracle 8 cause an ora-01002 error?
Oracle General 
