What is schema?41 38381
find out the third highest salary?92 92228
What are the composite date types in oracle?6 12482
diff between DELETE and TRUNCATE?.14 12166
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 9218
can we insert any row to dual table if i got the permission from DBA5 12504
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 7641
How to Remove the 3rd highest salary person record from table?9 9238
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 2388
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 2471
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 4915
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 5988
Write query to fetch second maximum salary from employee table.4 3714
Please guide me for Add new user test cases
How to Clear the recent Documents from the Start Menu?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
with a neat sketch, show all the interconnections required between a 8085 processor and a RAM of size 4KB mapped in the range 2000H-2FFFH.
differance between radix sort and radix exchange sort
What are the future plans for Apache?
What can go wrong if you have a balance sheet with a lot of debt? What can go wrong if there is negative owner's equity? What does a good cash flow statement look like and why?
The 4 main factors to start a construction project are––
How do I reconnect a project after the shared workspace file loses the project location?
How to find $ai_serual resolved path by using unix
hai friends .i applied for icici po callfor in july2010.i have been sortlisted for icici bank po and they fix the appoinment on july 31.so i don't know whether it is an interview or test or gd.can any body attend it already .please tell about it and how to prepare.my email id is email@example.com
CPC cable .PVC \1C....I want to get sure that type is flexible indoor or to be install on trench. please advice .thanx :)
total amount of milk produced each morning and then calculates and outputs the number of cartons needed for this milk , the cost of producing the milk and the profit from producing this milk.
Which is gives good performance idoc/ proxy?
What is Refuse Area In High Rise Building ?