4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
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 |
What is Hash Index?
How to convert dates to characters in oracle?
Why do we use bulk collect in oracle?
How to change system global area (sga) in oracle?
How to retrieve values from data fields in record variables?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to start a new transaction in oracle?
Where is the export dump file located?
What do you mean by a deadlock?
From the database level, how can you tell under which time zone a database is operating?
Why do we use coalesce function in oracle?
What is the relationship among database, tablespace and data file?