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
- 4722 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 |
What privilege is needed for a user to query tables in another schema?
What is the sid in oracle?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
What is an oracle data file?
how to clone 9i Database on to 10g Database.
How to open and close an explicit cursor in oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
Explain the use of full option in exp command.
can you explain performance tunning in oracle(sql,PL/SQL)
What are the predefined tablespaces in a database?
Where is the export dump file located?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Oracle General 
