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
- 4606 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 |
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
What is Redo Log Buffer in Oracle?
which is the best training centre for learning oracle?
What is ceil and floor in oracle?
How do you handle duplicate records in a database?
How many memory layers are in the oracle shared pool?
Respected sir, Please send me technical questions related to oracle apps..
What are the differences between interval year to month and interval day to second?
Explain mutating triggers.
Why do we use coalesce function in oracle?
How to Identify the previously inserted/updated records in already populated table.
Is it possible to insert comments into sql statements return in the data model editor ?
Oracle General 
