Interested to Buy Any Domain ? << Click Here >> for more details...
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>
- 2 Answers
- 5609 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is an oracle database?
What are the oracle built-in data types?
How index is implemented in oracle database?
What are nested tables?
How do I call oracle stored procedures that take no parameters?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Please explain oracle left join with an example?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to use "while" statements in oracle?
How many types of synonyms in Oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is the data type of dual table?
What is the relation of a user account and a schema?
What is translate in oracle?
