创建v_warehouseA视图
create or replace view v_warehouseA as
select warehouseid,description,username from warehouses
创建嵌套v_warehouseB 视图
create or replace view v_warehouseB as select * from v_warehouseA
查询视图
select * from v_warehouseB
创建v_warehouseA视图
create or replace view v_warehouseA as
select warehouseid,description,username from warehouses
创建嵌套v_warehouseB 视图
create or replace view v_warehouseB as select * from v_warehouseA
查询视图
select * from v_warehouseB