Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

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

HCL,

2 12589

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2030

query optmization techniques and quwry analyser+projects+ppts

2419

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 4469

how to find the n'th highest salary from emp ?

10 12527

how to find out second largest value in the table

8 9555

how to find out largest value in a table

2 4846

how to insert the image in table

2 6925

how to retrieve daily sal from emp table in oracle 10g

Infosys,

2 6937

What are steps required to ENTER DATA INTO DWH?

2 7824

which language is used to develop the oracle........?

Infosys,

4 13304

difference between truncate and delete ,drop?

3 7321

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5327

hai, when to use char and varchar2....?

2 5081

what is Single Byte Overhead...?

2550

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How many file formats are supported to export data?

1216

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1040

What are the restrictions on external table columns?

1052

How to list all indexes in your schema?

1087

What is memory advisor in Oracle?

1077

Explain what are synonyms used for?

1034

How to call a stored function in oracle?

1018

What is meant by raw datatype?

1056

How many types of synonyms in Oracle?

1117

Is there any function in oracle similar like group_concat of mysql?

1049

Define oracle database

1041

Write a syntax for update query in oracle?

1031

Why do you use stored procedures and state some of its disadvantages?

1026

Explain database link?

1112

What is recovery manager in Oracle?

1052

For More Un-Answered { Oracle General } Questions Click Here