Interested to Buy Any Domain ? << Click Here >> for more details...
4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
- 1 Answers
- 4607 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / girija.112
select 'Client '|| nvl (to_char(client_no),'unknown') ||'
has placed order to the value of '|| nvl(sum(order_no),0)
order_summary
from order
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 | 1 No |
Post New Answer View All Answers
How to pass parameters to procedures?
What is set verify off in oracle?
What are dml statements in oracle?
How to use "out" parameter properly?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What is ordinary table in oracle?
What types of joins are used in writing subqueries?
How to create a testing table in oracle?
What are the various types of snapshots ?
What is partitioned table in Oracle?
What is merge in oracle?
Query to retrieve record for a many to many relationship ?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to retrieve the count of updated rows?
Briefly explain what is literal? Give an example where it can be used?
