CREATE OR REPLACE VIEW view_table_name AS
SELECT USERNAME,PHONE,CERTNO,...
FROM USER_TABLE
view_table_name:视图表名
USER_TABLE:原始表名
CREATE OR REPLACE VIEW view_table_name AS
SELECT USERNAME,PHONE,CERTNO,...
FROM USER_TABLE
view_table_name:视图表名
USER_TABLE:原始表名