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 11446

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

1536

query optmization techniques and quwry analyser+projects+ppts

1898

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 3460

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

10 9672

how to find out second largest value in the table

8 7066

how to find out largest value in a table

2 3862

how to insert the image in table

2 5926

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

Infosys,

2 5697

What are steps required to ENTER DATA INTO DWH?

2 6730

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

Infosys,

4 11428

difference between truncate and delete ,drop?

3 6067

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.

4908

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

2 4060

what is Single Byte Overhead...?

2033


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle table?

536


What is a subquery in oracle?

554


How would you begin to troubleshoot an ORA-3113 error?

1562


What is a database table in oracle?

545


How to do clean up if create database failed?

547






candidate key is subset of super key but not vice-verse explain

1552


types of indexes and the rationale behind choosing a particular index for a situation.

1953


How do we get field detail of a table?

601


How to rename a column in an existing table?

592


How to store pictures on to the database?

508


How to load data through external tables?

557


What are the set operators union, union all, minus & intersect meant to do?

539


Why does Oracle not permit the use of PCTUSED with indexes?

1922


What is the difference between postgresql and oracle?

489


How many types of tables supported by oracle?

553