var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: snap with read only ?
I could see the "read only option" in creating views in Oracle ?
Is there anything like creating views with the option "snap with read only" ?
What does it mean ?
I came accross the below query :
create view view_name as select *from test snap with read only
Is there anything "snap with read only" in views (OR) "snap" is simply an alias for the table test ?
It is just an alias, as you can see by changing the DDL to:
The word "snap" doesn't make sense when it isn't right after the table name.
create view view_name as select * from test where 1=1 snap with read only
ERROR at line 1:
ORA-00933: SQL command not properly ended