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?
2032Hi 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 4485We 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.
5329Post New Oracle General Questions
what is the difference between data migration and production migration.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What privilege is needed for a user to query tables in another schema?
What are the different editions of oracle?
When do I need to use a semicolon vs a slash in oracle sql?
how do u setup a replication site?
How many types of table in Oracle?
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
What is difference between cartesian join and cross join?
How to loop through data rows in the implicit cursor?
How to write an inner join with the where clause in oracle?
How to use windows user to connect to the server?
Explain how are indexes update?
State any two functions of oracle?
Where are the settings stored for each instance in oracle?