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
- 5461 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the importance of .pll extension in oracle?
How to use an explicit cursor without open statements?
Differentiate between translate and replace?
What is blob datatype?
What is set operator oracle?
How to list all tables in your schema?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to create a table index?
How to drop an index in oracle?
What is an oracle database?
How to get a list of all background sessions in the database?
What is Segment Advisor in Oracle?
How to create a new table in oracle?
What are the general rules on data consistency?
What is BBED in Oracle?
