Answer Posted / ashok naik
Yes that is called indexed views using this we can improve
Query performance if your view contain single select
stament then we can easily establish unique clusterd index
| Is This Answer Correct ? | 63 Yes | 20 No |
Post New Answer View All Answers
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How many types of segments in Oracle?
What are the roles of dba?
How to write a query with a right outer join in oracle?
How to rebuild an index in oracle?
What is oracle host variable?
How to delete a column in an existing table in oracle?
How to concatenate two text values in oracle?
Explain table?
What is oracle join syntax?
How to do paging with oracle?
various types of hints and their usage
> 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?
State and explain the different types of data models?
What is a view and how is it different from a table?
