HCL Oracle General Interview Questions Answers, HCL Placement Papers, HCL Technical, HR Interview Questions, HCL Aptitude Test Questions, HCL Campus Placements Exam Questions

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 63323

find out the third highest salary?

92 151418

What are the composite date types in oracle?

6 18020

diff between DELETE and TRUNCATE?.

14 22678

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

2 12607

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

5 17295

ABOUT IDENTITY?

2064

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

7 12991

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

9 19126

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 5447

2 5271

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 8719

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 5204

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

5 19545

Write query to fetch second maximum salary from employee table.

4 7476

Post New HCL Oracle General Interview Questions

HCL Oracle General Interview Questions

HCL Oracle General Interview Questions (19)

Un-Answered Questions

How do I hide my wordpress site from public view?

189

How do I install a dll file in windows 8?

888

What the benefits are of hibernate over jdbc?

377

How do you enable temporary and extended trace logging for websphere portal ?

842

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1163

When should you build solutions declaratively instead of with code?

454

What are the key attributes?

346

Why should you be preferred over others?

1144

Tell me have you consistently met your sales goals?

1161

How do I open the source manager in word?

596

Explain what is meant by "business content" in sap?

900

If you want to direct people to specific pages on your website from an ad, you can create an ad that uses?

264

How to find the number of rows in db2 tables?

1073

How do I enable iis in my firewall?

1092

What kinds of decisions are most difficult for you at Henkel?

1109