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
- 4618 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
How to find no of saturdays in a month using single sql ?
Explain the use of full option in exp command.
What is the relation of a user account and a schema?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What are the different windows events activated at runtime ?
What is a Data Segment ?
Can u make a synonym for deptno=10 only from emp table.
What is the simplest tool to run commands on oracle servers?
25. Display the client number and the value of the highest value order placed by that client.
What is Hash Index?
Oracle General 
