4. Display the order number and client number from the ORDER
table. Output the result in the format. Client <clientno>
ordered <orderno>
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 |
how to store only time in a data base table
What is an oracle tablespace?
What are the different types of trigger and explain its various uses and functions?
How to use subqueries with the exists operator in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
what is Table ?
How to execute a stored program unit?
Explain oracle left join with an example?
What is an Oracle index?
How to name query output columns in oracle?
Is there a function to split a string in plsql?
create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......