What is schema?41 40301
find out the third highest salary?92 96387
What are the composite date types in oracle?6 13148
diff between DELETE and TRUNCATE?.14 12875
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error2 9804
can we insert any row to dual table if i got the permission from DBA5 13028
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?7 8021
How to Remove the 3rd highest salary person record from table?9 10194
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 2600
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 2701
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 5159
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 6909
Write query to fetch second maximum salary from employee table.4 4060
What is the difference between null and undefined?
What are the different networking options used in openstack?
Explain the pattern based data in automation anywhere?
Define what is the difference between active and passive filters?
From where was aryabhatta launched?
What is the purpose of plug-in tag in struct-config.xml?
Which property is used to set the text direction?
How do I create a directory in dos?
What is the difference between synchronous and asynchronous updates?
What is open sql?
What all the major containerization tools in devops ?
How to import vsam files from source to target. Do we need a special plugin?
IS THERE ANY DIFFERENCE BETWEEN PAID UP CAPITAL AND PAID IN CAPITAL?
"WHERE THERE IS A RIGHT, THERE IS REMEDY" EXPLAIN THIS WITH REFERENCE TO BREACH OF CONTRACT.
Which programming language is best to learn first?