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 52878

find out the third highest salary?

 92 128229

What are the composite date types in oracle?

6 15962

diff between DELETE and TRUNCATE?.

 14 17985

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

 2 11488

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

 5 15466

ABOUT IDENTITY?

 1553

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

 7 10767

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

 9 16328

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 4284

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 4213

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 7138

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 4184

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

 5 17342

Write query to fetch second maximum salary from employee table.

 4 5986

Post New HCL Oracle General Interview Questions


HCL Oracle General Interview Questions


Un-Answered Questions

how many drives do you have?

497

What will be the outcome of the following conditional statement if the value of variable s is 10?

753

Mention few features that Kotlin provides but not java ?

155

What are the two main categories of wage types? : hr- payroll

565

How quickly we need to fix the bug? Or how soon the bug should get fixed?

702




What is a byte array?

580

What is the oma?

522

what are rails filters?

532

What do you mean by Syntax Error

554

Which segment is used to store interrupt and subroutine return address registers?

754

What other technologies have you used in hadoop sta ck?

691

i had completed my degree with 72% but i dont have good score in gre and tofel and i got an admission into a college in usa is trheir will be any problem if i appear for visa regection because of gre and tofel and i am from science background i lost touch in those subjects.

1722

could u please also write an example of a code that involves instances from an abstract class just as u did for interfaces because u said it could also work which i really doubt. thanks

1618

Why do we use ms word?

292

Can we transmit digital signal to long distance ?

1478