In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
2 12459i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
7 12726Table1- 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 5301Table1- 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 5145You 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 8496create 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 19308Post New HCL Oracle General Interview Questions
What is default switch case? Give example.
what are the challenges you are faced with end users ?
How do I create a comma delimited text file?
What is a buffer in computer?
What are the new features provided in HTML5?
Is there a date data type in Hive?
What is j2ee and j2se?
What is DistributedCache and its purpose?
Explain the difference between fixed-bias circuit & self-bias circuit?
What is the test scenario to test a database migrated from one sql server to another?
What is constructor and destructor in c++?
If the emphasis in PeopleSoft 8 is the internet, why do we still need windows client?
Why is scala faster than java?
What is pca in ml?
Ellaborate viper architecture?