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 39498

find out the third highest salary?

92 94658

What are the composite date types in oracle?

6 12896

diff between DELETE and TRUNCATE?.

14 12560

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

2 9561





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

5 12855

ABOUT IDENTITY?

917

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

7 7864

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

9 9799

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 2532

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 2623

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 5064

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 2866

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

5 6563

Write query to fetch second maximum salary from employee table.

4 3917

Post New HCL Oracle General Interview Questions




HCL Oracle General Interview Questions





Un-Answered Questions

The “preserve” check box must only be used at what stage in blue prism?

1


What are common transport errors and their codes?

790


Define What is an ice dam sock?

13


The program will first compute the tax you owe based on your income. User is prompted to enter income. Program will compute the total amount of tax owed based on the following: Income Tax 0 - $45,000 = 0.15 x income $45,001 - $90,000 = 6750 + 0.20 x (income – 45000) $90,001 - $140,000 = 15750 + 0.26 x (income – 90000) $140,001 - $200,000 = 28750 + 0.29 x (income – 140000) Greater than $200,000 = 46150 + 0.33 x (income – 200000) Dollar amounts should be in dollars and cents (float point numbers with two decimals shown). Tax is displayed on the screen.

419


Is it possible to declare or create a cursor for update of table? If no tell me why?

7






what are bind variables?

14


What is vpn and how it works?

1


What is the problem with calling setstyle()? : adobe flex action script

1


How will you determine ranking values?

1452


what is the voltage regulation for unity and zero power factor?

1121


Can you explain events in google analytics?

1


what are your strengths & weekness ?

2730


How does the scope prototype work?

1


How can I scroll through list of pages like the search results in google?

6


What is the distance between each insulator in 33kv transformer and how can it calculate

1060