Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5594 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a dynamic performance view in oracle?
what is the use of system.effective.date variable in oracle?
Explain cascading triggers.
How to rename an index in oracle?
How to install oracle database 10g xe?
How to best split csv strings in oracle 9i?
What is connection pooling in oracle?
Is oracle the best database?
How to view existing locks on the database?
What is ceil and floor in oracle?
How will you write a query to get a 5th rank student from a table student_report?
How to export several tables together?
What are the different types of record groups in oracle? Explain each of them
How to insert multiple rows with one insert statement in oracle?
How to see the table columns used in an index?
