What is schema?41 42819
find out the third highest salary?92 102460
What are the composite date types in oracle?6 13792
diff between DELETE and TRUNCATE?.14 13792
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 10315
can we insert any row to dual table if i got the permission from DBA5 13538
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 8561
How to Remove the 3rd highest salary person record from table?9 11502
Table1- 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 this3 2908
Table1- 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 this2 2962
You 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 5497
create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
dbms_output.put_line ( int.ename||' '||int.deptno);
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
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 8003
Write query to fetch second maximum salary from employee table.4 4473
Define ibm mq series?
what is invertor supply and raw powersupply
How does recyclerview differ from listview?
When and how is feedback given to employees?
What is the use of defining a newobject in the object repository "Define New TestOject". How to use this further. If we define new testobject, how can it recognizes the objects properties of any application.
which are the criterias needed to select the kind of neutral earthing(solid earthing,resistance earthing,etc.) at various voltage levels in electrical distribution?
Is the cloud just a server?
Where is the user session timeout set and how do you set it?
what are three qualities that your friends will describe you having?
How to create fileupload field in apache-wicket?
Define ‘WhatID' and 'WhoID'.
What is css conflicting style?
What is autoproxying?
How will you create a progress bar using bootstrap?