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
- 5483 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
How to use null as conditions in oracle?
What is integrity and what is constraint??Explain with example
How to check your oracle database 10g xe installation?
Explain oracle left join with an example?
How to view existing locks on the database?
What are the attributes of cursor?
What is procedure overloading in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is a snapshot in oracle database?
What's dateware house and what's clustor with practicle example
various types of hints and their usage
What are the different editions of oracle?
What is bulk collect in oracle?
Difference between varchar and varchar2 data types?
How to manage transaction isolation level?
