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 52850

find out the third highest salary?

 92 128136

What are the composite date types in oracle?

6 15943

diff between DELETE and TRUNCATE?.

 14 17963

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

 2 11476

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

 5 15448

ABOUT IDENTITY?

 1549

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

 7 10760

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

 9 16315

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 4276

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 4199

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 7126

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 4178

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

 5 17303

Write query to fetch second maximum salary from employee table.

 4 5974

Post New HCL Oracle General Interview Questions


HCL Oracle General Interview Questions


Un-Answered Questions

How to sort query output in descending order in ms sql server?

526

How do you format cells in excel 2016?

299

What is the difference between oracle and MS Access?

604

What's the difference between visual studio community and professional?

499

Hi , I am a graduated in science at the year of 2006 & have started my professional career from that year as an HR personnel and still working. I have also got a bit of sales experiences in between this. Currently I am doing PGD in HRM from ICFAI & has done a Management Development Programme from IIM(Indian Institute of Management). My questions are 1) Am I moving in right direction towards my career ? 2)Will it be necessary to mention my Sales- Experience in my resume(as it was about 1yr.) , 3)What kind of job I can apply after finishing my PGD ?

1618




Sometimes, if I do not move the mouse, "click" and "mousedown" do not work. Why is that? : adobe flex action script

3

Explain me what are the different types of system involved in embedded system?

443

What is DDR (Double Data Rate)

1547

What is difference between factory and service?

399

What is Coupling?

660

What does *p++ do? What does it point to?

604

What is Individual and collective requirements and differecne between them in MTO scenario?

1565

Can you please explain the difference between mutexes vs semaphores?

433

compare brayton and otto cycle

1838

What is the Systematic Responsibility Site Engineer? Who are the above and under co-oridinating ? What is office & Site co-ordination of Site Engineer?

1658