1017 database indexes, views, materialized views

--Get the current value of the sequence select Sq_test.nextval from  dual;  --Remove a value select Sq_test.currval from dual;  --Current value insert into T_user values (Sq_test.nextval, ' Zhang San ' | | sq_test.currval); commit;---view select * from V_score;----Index Select T.sname from student t where sname= ";--physical attempt to select T.*, t.rowid from mv_test t--Call stored Procedure--Refresh physical view exec DBMS_MVIEW.REFRESH_MV (' Mv_test ');  --This statement needs to be executed under the New-command window, then query the physical view to see the modified data

　　

1017 database indexes, views, materialized views