Interested to Buy Any Domain ? << Click Here >> for more details...
How can we force the database to use the user specified rollback segment?
- 0 Answers
- 1119 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
State the difference between a primary key and foreign key?
What is the difference between SQL and SQL Server?
Explain oracle left join with an example?
wirte the syntax of update query?
How to list all tables in your schema?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to pass parameters to procedures in oracle?
How can you merge two tables in oracle?
> 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?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
How many types of database triggers exist?
How to delete all rows a table in oracle?
Oracle General 
