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
- 5506 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 Redo Log Buffer in Oracle?
Explain rename?
definition of cluster and non-clustered index?
Point the difference between translate and replace?
What are the attributes of the cursor?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the different types of database objects?
How do I escape a reserved word in oracle?
How different is ms access and oracle?
What is a dead lock in oracle?
Which is faster join or subquery in oracle?
How to delete a user account in oracle?
How to return top 5 rows in oracle?
What is a proxy class?
What are the attributes that are found in a cursor?
