Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lokanath
View is basically a Stored Query. we can call it as Logical
representaion of table. View Doesnot contain data. But
Materialized view Contains data. Because Materialised view
contains results of a Query.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of tables, private synonyms and public synonyms in Oracle?
what is the scripts in data base?
Explain cascading triggers.
What is set operator oracle?
How a tablespace is related to data files?
> 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?
How to create a new table in your schema?
How to declare a local variable?
How to get a create statement for an existing table?
Can we write dml statement in function in oracle?
What do you mean by redo log file mirroring?
How to use "in" parameter properly?
Name the three major set of files on disk that compose a database in Oracle?
What is instant client oracle?
What are nested tables?
