视图可以这样用吗

Question

SQL> select * from t;                                     ID DATA
--------------------------------------- ------------------------------
                                      1 dfdfdlslf
                                      2 fdfdvvvvvvvvvvvvvSQL> create or replace view v_t as select * from t;View createdSQL> insert into v_t values(3,'ddd');1 row insertedSQL> select * from v_t;                                     ID DATA
--------------------------------------- ------------------------------
                                      1 dfdfdlslf
                                      2 fdfdvvvvvvvvvvvvv
                                      3 ddd

Answer 1

默认是可以修改，create or replace view v_t as select * from t readonly;
就可以设置为只读。