What is schema?41 42066
find out the third highest salary?92 100741
What are the composite date types in oracle?6 13623
diff between DELETE and TRUNCATE?.14 13513
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 10221
can we insert any row to dual table if i got the permission from DBA5 13402
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 8399
How to Remove the 3rd highest salary person record from table?9 11190
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 2820
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 2891
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 5407
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 7673
Write query to fetch second maximum salary from employee table.4 4353
What are mysql functions?
Is it possible to have a static indexer in c#? Allowed in c#.
What is compact in laravel?
Where is the location of vikram sarabhai space centre?
How would you add comments to a cell?
What are lvalue and rvalue?
What is an oracle?
How do I access environment variables from python?
What are the cookies methods?
Is oracle dba in demand?
What is drop cap?
What is the component processor?
What is java flatmap?
What are internal tables? How to use a specific number occurs statement?
How to code the db2 queries using rexx?