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 12598

> 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

2421

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 4483

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

10 12554

how to find out second largest value in the table

8 9580

how to find out largest value in a table

2 4855

how to insert the image in table

2 6929

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

Infosys,

2 6947

What are steps required to ENTER DATA INTO DWH?

2 7830

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

Infosys,

4 13316

difference between truncate and delete ,drop?

3 7332

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.

5329

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

2 5100

what is Single Byte Overhead...?

2555

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is a relational database management system?

1120

Â How to use an oracle sequence generator in a mapping?

1075

What is an index associated with a constraint?

1040

How many types of table in Oracle?

1122

Explain oracle 12c new features for developers?

1058

What is the difference between count (*), count (expression), count (distinct expression)?

1005

How to start your 10g xe server?

1041

What happens if you use a wrong connect identifier?

1065

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1786

How to connect to the server with user account: sys?

1019

What is control file used for?

1209

How to run the anonymous block again?

1132

what are archived logs?

2199

What is raw datatype in oracle?

1135

Explain about achiever in sql?

1035

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