4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
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 is set verify off in oracle?
Describe varray?
Can you create a synonym without having a table?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Which is better Oracle or MS SQL? Why?
Is a rollback possible to any savepoint?
Explain about the analyze command in oracle?
How to see free space of each tablespace?
How to count duplicated values in a column in oracle?
What are the roles of dba?
How to use "while" statements in oracle?
material view and view disadvantages?
What happens if variable names collide with table/column names?
What is the best way to do multi-row insert in oracle?
how the indexes are stored in the Oracle Database?