18. Display the clientno and total value for all orders
placed by that client. Output the result in the following
format: Client <clientno> has placed orders to the value of
<total value>
Answers were Sorted based on User's Feedback
Answer / girija.112
i forgot to login thats why i have posted it once again
ANS:
select 'Client '||nvl(tochar(client_no,'unknown') ||' has
placed orders to the value of '|| nvl(sum(orders),0) as
order_summary
from order_table
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 | 0 No |
Answer / guest
ANS:
select 'Client '||nvl(tochar(client_no,'unknown') ||' has
placed orders to the value of '|| nvl(sum(orders),0) as
order_summary
from order_table
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 ? | 0 Yes | 1 No |
Explain the features of oracle?
How to convert raw data type into text in oracle? Explain
What is difference between a formal and an actual parameter?
20. Using a set operator, display the client number of all clients who have never placed an order.
Describe varray?
how to genarate random numbers in oracle for particular row?
Explain an index?
Why oracle is used?
What are the ansi data types supported in oracle?
What is an oracle function?
what is the scenario where you take the database to NoArchivelog mode?
3. Display all the client numbers in the ORDER table. Remove duplicates.