Answer Posted / nishi
Snapshots and Materialized view are used interchangeably as both are almost same. However, materialized view is having additional feature of query rewrite which is not in snapshot.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the difference between sap and oracle?
Why should I use oracle database?
How to define an anonymous procedure without variables?
How to create an oracle testing table?
How many anonymous blocks can be defined?
How to open and close an explicit cursor in oracle?
How to select an oracle system id (sid)?
How would you begin to troubleshoot an ORA-3113 error?
How to concatenate two text values in oracle?
What is a subquery in oracle?
How to assign values to variables?
What is a cursor and what are the steps need to be taken?
> 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?
What is data file?