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
- 5616 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
What is blob datatype?
What is a cursor and what are the steps need to be taken?
What are the limitations of check constraint?
What is ASM (Automatic Storage Management) in Oracle?
Explain the use of consistent option in exp command.
Explain the use of compress option in exp command.
How to export data with a field delimiter?
What are operators in oracle?
How many types of cluster table in Oracle?
How to put more than 1000 values into an oracle in clause?
What is a nvl function?
Explain oracle 12c new features for developers?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is oracle and what are its different editions?
How many categories of data types in oracle?
