Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 45581

find out the third highest salary?

92 109477

What are the composite date types in oracle?

6 14356

diff between DELETE and TRUNCATE?.

14 14929

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

2 10654





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

5 14095

ABOUT IDENTITY?

1232

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

7 9130

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

9 12909

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 3259

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 3261

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 5886

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 3507

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

5 10646

Write query to fetch second maximum salary from employee table.

4 4913

Post New HCL Oracle General Interview Questions




HCL Oracle General Interview Questions


Un-Answered Questions

Explain shape of the earth?

255


What is the distinction between a fast filter and traditional filter in tableau?

85


What is session object in hibernate?

33


How can MYSQL functions be available with PHP?

285


What are the functions of using availability check?

240






Define views in teradata with syntax.

308


How do I insert a list of figures in word?

165


Can you split a cell in excel 2016?

122


In Manual testing how to test proxy servers? can u please explain with example?

1254


What does an operations manager do?

283


What is the difference between the scalability and elasticity?

146


Where is system windows forms dll?

251


How to generate the report from excel sheet?

289


What is the iis service called?

250


Explain the term HCatalog?

1