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
4707 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

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1078

is there a tool to trace queries, like profiler for sql server?

1141

What is an oracle function?

1165

How to add a new column to an existing table in oracle?

1139

What is the parameter mode that can be passed to a procedure?

1047

Describe the types of sub query?

997

How do I spool in oracle?

1004

Whats the benefit of dbms_stats over analyze?

2002

What is an oracle transaction?

1146

How to define a record variable to store a table row?

1058

What is a package in oracle?

1102

How to define a data field as not null?

1108

What would you do with an in-doubt distributed transaction?

1979

What is private procedure oracle?

1010

Why we use bulk collect in oracle?

1044