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 52914

find out the third highest salary?

 92 128490

What are the composite date types in oracle?

6 15969

diff between DELETE and TRUNCATE?.

 14 18030

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

 2 11492

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

 5 15478

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 10775

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

 9 16353

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 4291

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 4219

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 7154

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 4189

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

 5 17357

Write query to fetch second maximum salary from employee table.

 4 6009

Post New HCL Oracle General Interview Questions


HCL Oracle General Interview Questions


Un-Answered Questions

What is the formula for knowing keyword density?

422

How will you get the natural logarithm of the given number in vbscript?

599

Briefly state different between data ware house & data mart?

550

Explain in brief about Microsoft SQL server?

543

How the Kernel handles both the page stealer and the fault handler?

615




What does namespace mean in c++?

548

Tell me what is the difference between ereg_replace() and eregi_replace()?

539

can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?

1680

How do I send escape sequences to control a terminal or other device?

603

How to set up routing in reactjs?

156

What is msdb database? : SQL Server Architecture

531

What does allotropic mean?

554

What are friend classes? What are advantages of using friend classes?

601

how can service sitting be setted for MCCB?Example for sittings IR (CURRENT RATING),IS(CURRENT STARTING)IO (current operating)?

1682

What is the resourcebundle class?

525