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
- 4696 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 |
Is it possible to split the print reviewer into more than one region ?
What is an index associated with a constraint?
Explain the different normalization forms?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How do I know if oracle client is installed on windows?
How to check the oracle tns settings?
what is shell?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is bind variable in oracle 11g?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What are the basic element of Base configuration of an oracle Database ?
What is the use of oracle?
Oracle General 
