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 41246

find out the third highest salary?

92 98741

What are the composite date types in oracle?

6 13430

diff between DELETE and TRUNCATE?.

14 13241

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

2 10055





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

5 13252

ABOUT IDENTITY?

1003

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

7 8244

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

9 10682

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 2734

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 2818

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 5291

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 3134

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

5 7302

Write query to fetch second maximum salary from employee table.

4 4234

Post New HCL Oracle General Interview Questions




HCL Oracle General Interview Questions


Un-Answered Questions

Is mac terminal unix?

66


Can I use .net components from com programs?

105


Explain about the architecture of MYSQL?

110


What is multithreading? What are the problems that comes with multithreading and how to manage them?

105


what is your opinion regarding T.V shows on youth

1584






How to redirect https to http url through .htaccess?

72


How to calculate the Efficiency of Chiller

2322


How do I get the classic start menu in windows 10?

45


What is boolean flag in java?

60


How do you insert a vertical divider in word?

31


Which js framework is best with laravel?

45


What is the command for archiving a group of files in hdfs.

1


Consider the following code: 1 2 3 4 5 (function() { var a = b = 5; })(); console.log(b); what will be printed on the console?

71


Which company is the leading manufacturer of Thin Clients in cloud computing?

51


Why do you use two ground pins in microprocessor 8086?

76