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
4680 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 to experiment a data lock in oracle?

1040

Is it possible to split the print reviewer into more than one region ?

2261

Explain an extent?

1086

What is the difference between PFILE and SPFILE in Oracle?

1038

Explain the difference between replace() and translate() functions in oracle?

1021

How can windows applications connect to oracle servers?

1039

How to create a new table in your schema?

1067

How to login to the server without an instance?

1146

Can group functions be mixed with non-group selection fields?

1008

What is oracle update statement with inner join ?

1033

How to export several tables together?

1032

Explain overloading. Can functions be overloaded?

965

What is ASM (Automatic Storage Management) in Oracle?

1179

What is a Garbage Collection? and what is full recursive Garbage collection?

2884

Explain temporal data types in oracle

1077