select 'Client '|| nvl (to_char(client

4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>

Question Posted / girija.112

1 Answers
4697 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

Please Help Members By Posting Answers For Below Questions

What is a lookup table in oracle?

967

Explain the use of rows option in exp command.

1084

How to pass parameters to procedures?

1026

What is oracle latest version?

1092

Can we store images in oracle database?

1001

What is a view and how is it different from a table?

1037

How to use an explicit cursor without open statements?

1051

What is oracle data type?

957

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1030

What is a user account in oracle?

1117

How do I connect to oracle?

1027

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4164

How can we find out the current date and time in oracle?

1086

How to store pictures on to the database?

967

What is the difference between translate and replace in oracle?

1159