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
- 5453 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
how may join possible between (requisition with purchase order)
What are the various constraints used in oracle?
Explain an extent?
how to make an oracle object
How to retrieve data from an cursor to a record?
What is concurrency in oracle?
How to execute a stored procedure in oracle?
Explain the use of control file?
What is Trigger in Oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain table?
Differentiate between function and procedure in oracle.
Where do you use decode and case statements?
What is program global area (pga) in oracle?
