What is schema?41 38690
find out the third highest salary?92 92938
What are the composite date types in oracle?6 12611
diff between DELETE and TRUNCATE?.14 12290
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 9349
can we insert any row to dual table if i got the permission from DBA5 12634
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 7709
How to Remove the 3rd highest salary person record from table?9 9410
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 2445
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 2527
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 4981
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 6202
Write query to fetch second maximum salary from employee table.4 3784
CASH SALE OF Rs. 10000/- WITH TAX. THEN WHAT SHOULD BE THE ENTRY BEHIND THIS IN BOTH SIDE SALES AND TAXATION.
what is your experience in medical continuing education.
Would you like to ask us any questions?
Tell me about a time when you had too many things to do and you were required to prioritize your tasks
A company charity (gross income 250k) wishes to take advantage of the audit exemption regime. However, there is an audit provision in the company's Articles. Should they be required to change the Articles?
How we can test Cookies Manually?
Hi I have done my bachelors in mechatronics engineering and PG diploma in industrial automation having 2 years of experience as electrical & instrumentation engineer in a ltd company I need to know for what all technical certification can I go for
What is spectral sensitivity?
GUYS any one please can u post questions in sap a bap webdynpro questions.. please i need to know some technical questions regarding webdynpro and ADOBE forms ?
whats is statement and procedure
what is the diffrence between software and hardware language?
11. Display the client number and name and the client number and name of the person who referred that client.
1)how do you created structured products in CRM?
Can you please let me know the centre name of INS certification in Kolkata.
Will Events Are Also Copied On Clone In Jquery?