4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
- 1 Answers
- 4326 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
How to rename an existing table?
How to connect to the server with user account: sys?
How to drop a tablespace?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are the different types of synonyms?
What is the difference between online and offline backups?
How can I combine multiple rows into a comma-delimited list in oracle?
How can we view last record added to a table?
How to increment dates by 1 in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain oracle left join with an example?
