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 65498

find out the third highest salary?

 92 156391

What are the composite date types in oracle?

6 18482

diff between DELETE and TRUNCATE?.

 14 23699

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

 2 12814

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

 5 17719

ABOUT IDENTITY?

 1 2188

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

 7 13462

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

 9 19741

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 5744

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 5510

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 9049

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 5366

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

 5 19967

Write query to fetch second maximum salary from employee table.

 4 7834

Post New HCL Oracle General Interview Questions


HCL Oracle General Interview Questions


Un-Answered Questions

The following are the list of Balances of SUNSHINE Company as at 1.2.2012 RM Land and building 450,000. Furniture and Fittings 35,000. Office Equipment 25,000. Motor Vehicles 75,000. Inventory 5,000. Trade Receivables 12,000. Trade Payables 8,000. Bank Loan 200,000. Bank 13,000. Cash in Hand 1,000. Capital 408,000.

1867

I want recent question papers. Now am preparing for BPO interview. please send the papers..

3115

please somebody who have asked questions related to electronic and communication eng siemens 2010-2012 post here

2038

why c is called middle level langauge?

2148

hi, if anyone have previous year paper of NHPC or some questions, Please send me at gupta.pankaj20@gmail.com

2973

What would be your first invention?

1292

What's happening in the news right now, both in your country and abroad? Where did you hear about it?

2609

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2869

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1165

Describe a situation in which your work was criticized?

1383

Draw the symbol of jfet and mosfet.

1336

What does $_files means?

1195

Write down a program for comparison of strings in any language you know?

1265

What is the per cu. mt. price of ready mix in Gujarat region.?

2456

How much does a windows 10 license cost?

974