In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
2 12502i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
7 12823Table1- 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 5348Table1- 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 5180You 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 8563create 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 19389Post New HCL Oracle General Interview Questions
What are the feature of reactjs?
How do you install an extension in joomla?
How would you solve problems if you were from Mars?
What is the default value for personnel subarea and business area?
Why does jvm come up automatically though I stop/kill the process manually?
What are the applications of autotransformers?
Explain what are the two mechanisms of breakdown in a p-n junction?
Which permission needed in order to use mapactivity?
how to convert lv line to hv line and viseversa, any losses will occur during this process
What is r matrices?
Define distributed query and linked server?
Can I buy just ms word?
why us? why bba? how do i know that u will be returning back to india? and iw anna to ask i have a gap between my hsc examination of which i have sone in 2003 now i m applying for f1 visa as a bba if they ask y this gap what wil be the ans plaese sugest me fast plzzzzzzz?
What are Visual Debugger?
What is lst file?