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 meant by raw datatype?
What are the uses of synonyms?
How to create a table interactively?
What happens to the data files if a tablespace is dropped?
How to get execution path reports on query statements?
Differentiate between pre-select and pre-query?
How to open and close an explicit cursor in oracle?
What is program global area (pga) in oracle?
What is the relation of a user account and a schema in oracle?
What is the difference between translate and replace?
Explain what are synonyms used for?
How to execute a stored program unit?
Explain the difference between replace() and translate() functions in oracle?
Hi Can any one tell me what are the API's used in requisition import.
Explain enable novalidate constraint.