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 64434

find out the third highest salary?

92 153838

What are the composite date types in oracle?

6 18218

diff between DELETE and TRUNCATE?.

14 23112

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

2 12695

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

5 17465

ABOUT IDENTITY?

2110

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

7 13166

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

9 19385

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 5575

2 5379

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 8867

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 5278

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

5 19712

Write query to fetch second maximum salary from employee table.

4 7632

Post New HCL Oracle General Interview Questions

HCL Oracle General Interview Questions

HCL Oracle General Interview Questions (19)

Un-Answered Questions

How to find out number of parameters passed into function?

218

Explain elastic block storage? What type of performance can you expect? How do you back it up? How do you improve performance?

343

How can you schedule a sqoop job using Oozie?

How to list or view all databases from the mysql server.

979

What are key words in python?

923

Explain "VAR_INPUT" when defining a Function Block??

2013

What are the 2 modes used to run pig scripts?

649

What is the difference between a default skin and a named skin?

1149

When thomas edison was promoting the wide use of direct current, this personal enemy of edisons was the chief proponent and expert in alternating current?

1006

Is Constructor possible in abstract class in java ?

1118

What are the different types of risk?

657

What is an editor?

1108

What is eomonth?

653

What is the purpose of xssfcreationhelper class in apache poi?

What are the different elements of jconsole?