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
Explain enable novalidate constraint.
What are the different oracle database objects?
> 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?
Can we save images in a database and if yes, how?
How a database is related to tablespaces?
How many categories of data types in oracle?
How to delete multiple rows from a table in oracle?
Explain the dml?
What is a static data dictionary in oracle?
How to define default values for formal parameters?
What are the ansi data types supported in oracle?
How to see the table columns used in an index?
State any two functions of oracle?
How to define a cusotmer as a supplier in ORACLE R12
How are extents allocated to a segment?
