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 12685

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

2089

query optmization techniques and quwry analyser+projects+ppts

2464

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 4585

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

10 12802

how to find out second largest value in the table

8 9775

how to find out largest value in a table

2 4955

how to insert the image in table

2 7033

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

Infosys,

2 7155

What are steps required to ENTER DATA INTO DWH?

2 7919

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

Infosys,

4 13425

difference between truncate and delete ,drop?

3 7454

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.

5374

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

2 5195

what is Single Byte Overhead...?

2611

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to import one table back from a dump file?

1081

Compare and contrast between sql and sql server and explain its various functions?

1015

Can we call procedure inside function in oracle?

1147

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2261

How to create a new tablespace in oracle?

1030

What types of joins are used in writing subqueries?

1030

Explain a data segment?

1112

What is Virtual Private Database in Oracle?

1147

Differentiate between function and procedure in oracle.

1150

How to use "while" statements in oracle?

1375

In which language oracle has been developed?

1134

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2517

What is using clause and give example?

1106

Query to retrieve record for a many to many relationship ?

2573

How to write a query with a left outer join in oracle?

1123

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