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
- 4679 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 |
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Is there any function in oracle similar like group_concat of mysql?
What is the function of Redo Log ?
How to commit the current transaction in oracle?
What is an oracle recycle bin?
What is Trace File ?
how to handle exceptions in post production
How do I spool to a csv formatted file using sqlplus?
What is transport network substrate (tns) in oracle?
How to use windows user to connect to the server?
State and explain about oracle instance?
how the indexes are stored in the Oracle Database?
Oracle General 
