What is schema?41 45581
find out the third highest salary?92 109477
What are the composite date types in oracle?6 14356
diff between DELETE and TRUNCATE?.14 14929
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 10654
can we insert any row to dual table if i got the permission from DBA5 14095
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 9130
How to Remove the 3rd highest salary person record from table?9 12909
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 3259
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 3261
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 5886
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 10646
Write query to fetch second maximum salary from employee table.4 4913
Explain shape of the earth?
What is the distinction between a fast filter and traditional filter in tableau?
What is session object in hibernate?
How can MYSQL functions be available with PHP?
What are the functions of using availability check?
Define views in teradata with syntax.
How do I insert a list of figures in word?
Can you split a cell in excel 2016?
In Manual testing how to test proxy servers? can u please explain with example?
What does an operations manager do?
What is the difference between the scalability and elasticity?
Where is system windows forms dll?
How to generate the report from excel sheet?
What is the iis service called?
Explain the term HCatalog?