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 12459

> 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?

1983

query optmization techniques and quwry analyser+projects+ppts

2372

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 4330

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

10 12196

how to find out second largest value in the table

8 9239

how to find out largest value in a table

2 4721

how to insert the image in table

2 6805

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

Infosys,

2 6694

What are steps required to ENTER DATA INTO DWH?

2 7682

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

Infosys,

4 13129

difference between truncate and delete ,drop?

3 7165

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.

5289

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

2 4962

what is Single Byte Overhead...?

2500

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to pass parameters to procedures?

975

How to create a table index?

1063

What happens if you lost a data file?

980

How to count duplicated values in a column in oracle?

985

What is the max number of columns in an oracle table?

932

What are the general rules on data consistency?

960

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1873

How do I escape a reserved word in oracle?

1132

how the indexes are stored in the Oracle Database?

2214

Hi Can any one tell me what are the API's used in requisition import.

1881

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

968

Give the constructs of a package, function or a procedure.

984

What are the types of partitions in oracle?

976

how to handle exceptions in post production

1362

Can you assign multiple query result rows to a variable?

933

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