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 12479

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

1990

query optmization techniques and quwry analyser+projects+ppts

2378

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 4361

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

10 12249

how to find out second largest value in the table

8 9301

how to find out largest value in a table

2 4747

how to insert the image in table

2 6827

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

Infosys,

2 6748

What are steps required to ENTER DATA INTO DWH?

2 7707

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

Infosys,

4 13163

difference between truncate and delete ,drop?

3 7200

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.

5293

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

2 4995

what is Single Byte Overhead...?

2506

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is blob datatype?

1065

How to retrieve data from an explicit cursor?

1016

When do I need to use a semicolon vs a slash in oracle sql?

1040

How to insert a record into a table?

1032

What is bulk copy or bcp in oracle?

1063

Can we use bind variables in oracle stored procedure?

910

Can we connect to ORACLE db using Windows Authentication?

1196

What happens to the current transaction if the session is killed?

937

How to handle a single quote in oracle sql?

984

How much memory your 10g xe server is using?

1061

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4481

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1338

Explain rename?

933

What is PL/SQL ?

1929

List out the types of joins.

1094

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