4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
- 1 Answers
- 4322 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
7. Repeat query (7) but also display all clients who have never ordered anything.
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
What is Undo Management Advisor in Oracle?
What is an Oracle index?
What is the maximum number of CHECK constraints that can be defined on a column ?
How to use "while" statements in oracle?
What is difference between truncate and delete?
How do I uninstall oracle 11g?
How to export data to a csv file?
What is the difference between translate and replace?
What is an oracle?
How to rename an index in oracle?
Oracle General 
