In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
2 12391i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
7 12571Table1- 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 5246Table1- 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 5087You 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 8398create 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 19182Post New HCL Oracle General Interview Questions
What are the major skills data scientist need?
Explain form level validation and field level validation?
What is strongly typed view in mvc?
What is report template in b.o?
Explain various cluster manager in Apache Spark?
What is the disadvantage of using a macro?
What are some best practices when creating complex models in excel?
How do you stop the currently-running animation? : jquery mobile
Explain me can we use printf inside isr?
How is dag created in spark?
Does ram affect excel performance?
How many effort estimation methods available in market for testing?
What is the character limit for adwords ads?
What is MongoDB?
Explain the difference between creating an effect and setting the target as opposed to adding an effectlistener?