Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

HCL Oracle General Interview Questions
Questions Answers Views Company eMail

What is schema?

41 52510

find out the third highest salary?

92 127388

What are the composite date types in oracle?

6 15859

diff between DELETE and TRUNCATE?.

14 17809

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 11431

can we insert any row to dual table if i got the permission from DBA

5 15373

ABOUT IDENTITY?

1533

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 10664

How to Remove the 3rd highest salary person record from table?

9 16195

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 this

3 4230

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 this

2 4165

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 7066

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 4145

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

5 17193

Write query to fetch second maximum salary from employee table.

4 5910

Post New HCL Oracle General Interview Questions


HCL Oracle General Interview Questions


Un-Answered Questions

Where is microsoft photos exe located?

457


What is conditional probability explain with an example?

70


What is an oracle recycle bin?

518


What is structure?

547


Will iphone 6s get ios 14?

415






Will you be ready to relocate to the job locations we offer you

649


Explain about PHP filter and why it should be used?

533


How do I cancel windows 10 update in progress?

406


What are Nameless Sockets?

1036


Hibernate Session is thread safe?

152


Write the expression for discrete convolution.

605


What is the difference between Fe 500, Fe 500 D and Fe 515.

3624


How to use filtering function in xslt? : xslt

478


What is .net mobile forms? : Microsoft dot net mobile

486


Why do you use work modes in sap solman?

1