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
- 5072 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Can we store images in oracle database?
Can the default values be assigned to actual parameters?
What is a Database instance ? Explain?
 What are the oracle DML commands possible through an update strategy?
How to change user password in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
select statement does not retrieve any records. what exception is raised?
how to handle exceptions in post production
What are the differences between char and nchar in oracle?
How to return top 5 rows in oracle?
What are the uses of synonyms?
Oracle General 
