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
- 4727 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / girija.112
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 |
Post New Answer View All Answers
What happens to the data files if a tablespace is dropped?
How do we get field details of a table?
How do I connect to oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is a proxy class?
What is an oracle and why it is used?
What is the recommended interval at which to run statspack snapshots, and why?
How can I create database in oracle?
How to turn on or off recycle bin for the instance?
How to shutdown your 10g xe server from command line?
Explain oracle instance.
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What do you mean by a tablespace?
How many categories of data types?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
