Answer Posted / orawhiz
A Database contains one or more Rollback Segments to
temporarily store "undo" information.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to retrieve the count of updated rows?
What is ADDM Advisor in Oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What are the original export and import utilities?
> 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?
Is a rollback possible to any savepoint?
Describe the types of sub query?
How do I limit the number of rows returned by an oracle query after ordering?
What is Virtual Private Database in Oracle?
How view is different from a table?
Explain integrity constraint?
What is concurrency in oracle?
What is the difference between alert log file and tarce file ?
What is query image?
State and explain about oracle instance?