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
- 5695 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
How do I manually create a database in oracle?
is there a tool to trace queries, like profiler for sql server?
How can Oracle users be audited?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Where do you use decode and case statements?
what is the difference between restoring and recovering?
what is port in oracle? how is it related to database application.
What is a cognitive schema?
How many anonymous blocks can be defined?
How to create a new table in your schema?
How to create a new table in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
How to start an oracle instance?
What is the difference between 10g OEM and 11g OEM?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
