Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
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?

 2032

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 4485

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

 10 12558

how to find out second largest value in the table

 8 9582

how to find out largest value in a table

 2 4858

how to insert the image in table

 2 6931

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

Infosys,

2 6949

What are steps required to ENTER DATA INTO DWH?

 2 7831

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

Infosys,

4 13316

difference between truncate and delete ,drop?

 3 7337

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 5103

what is Single Byte Overhead...?

 2556

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

what is the difference between data migration and production migration.

2346

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2287

What privilege is needed for a user to query tables in another schema?

973

What are the different editions of oracle?

1109

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

1090

how do u setup a replication site?

1989

How many types of table in Oracle?

1124

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

2207

What is difference between cartesian join and cross join?

1089

How to loop through data rows in the implicit cursor?

1074

How to write an inner join with the where clause in oracle?

1045

How to use windows user to connect to the server?

990

Explain how are indexes update?

1065

State any two functions of oracle?

1046

Where are the settings stored for each instance in oracle?

1105

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