What is schema?41 38118
find out the third highest salary?92 91540
What are the composite date types in oracle?6 12356
diff between DELETE and TRUNCATE?.14 12046
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 9087
can we insert any row to dual table if i got the permission from DBA5 12388
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 7561
How to Remove the 3rd highest salary person record from table?9 8955
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 2325
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 2421
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 4865
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 5737
Write query to fetch second maximum salary from employee table.4 3614
What is Binary operations?
Which is the best field foundation bus. ( FF ) Yokogawa, Honeywell or others ?
difference between Ac and Dc mcb ????
In General please do read newspapers.And be thorough with 10th history and Geography.Biology also
could anyone send me model question papers or outline of graduate trainee(chemical engg) post?
I am student pursuing B.E/B.tech in Computers 8'th sem.What should i do for a better carrier.Plz suggest other than programming languages.Is the ERP a better one to do?plz help...
A ii kv 1200 A Breaker combination fixed in a cubicle. How many ampere Fuse is required? If fuse is not using, Why?
If one tertiary phase i.e. R,Y or B is earthed of a loaded type tertiary delta connected (Without load)of a power auto transformer, what is its advantage/disadvantage?
hey guys ... since i have just started my career i need to know whether testing has a good career or not .. ?
Can I know about SAP for Insurance.
a cc. has balance Rs. 8,40,000 at the credit of profit and loss a/c this balance is used for redemption of debentures what will be the entry
How can we connect additional batteries to three phase ups? What are parameters we have to check when connecting?
code for quick sort?
What are the regulatory commitments in markets like USA, Canada, Europe, Brazil, South Africa and Japan
what are the types of design? which type of method is used at what type of design & why?