In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
2 11431i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
7 10664Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
3 4230Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
2 4165You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
3 7066create 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 => ..
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
5 17193Post New HCL Oracle General Interview Questions
Where is microsoft photos exe located?
What is conditional probability explain with an example?
What is an oracle recycle bin?
What is structure?
Will iphone 6s get ios 14?
Will you be ready to relocate to the job locations we offer you
Explain about PHP filter and why it should be used?
How do I cancel windows 10 update in progress?
What are Nameless Sockets?
Hibernate Session is thread safe?
Write the expression for discrete convolution.
What is the difference between Fe 500, Fe 500 D and Fe 515.
How to use filtering function in xslt? : xslt
What is .net mobile forms? : Microsoft dot net mobile
Why do you use work modes in sap solman?