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
- 5699 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
Explain the use of control file?
What is a cursor and what are the steps need to be taken?
Can select statements be used on views in oracle?
Whether any commands are used for months calculation? If so, what are they?
Can the query output be sorted by multiple columns in oracle?
How to rollback the current transaction in oracle?
What is analyze command used for?
What are the varoius components of physical database structure of oracle database?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How do I recompile a procedure in oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
Explain compound trigger in oracle?
What is an oracle database?
How do I connect to oracle database?
WHAT IS ecc 6.0
