Interested to Buy Any Domain ? << Click Here >> for more details...
4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
- 1 Answers
- 4801 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
What is the dynamic sql in oracle?
Can the query output be sorted by multiple columns in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the maximum number of triggers that can be applied to a single table?
How to work with data objects interactively?
Explain the use of indexes option in imp command.
What is the relation of a user account and a schema?
What privilege is needed for a user to insert rows to tables in another schema?
What types of joins are used in writing subqueries?
How to update values on multiple rows in oracle?
How to recover a dropped table in oracle?
Design database draw er diagram for a certain scenario ?
What would you do with an in-doubt distributed transaction?
Explain a segment?
