create view wangluotuku as select t1.z1,t1.z3,t2.a1,t2.a2,t3.b1,t3.b3,t4.c1,t4.c2, t5.d1,t5.d3,t6.e1,t6.e2,t7.f1,t7.f3,t8.g1,t8.g2 from t1,t2,t3,t4,t5,t6,t7,t8
create view wangluotuku as select t1.z1,t1.z3 .......... from t1,...... t8;
create view v_wangluotuku as select .......
create view viewname as select ....... 同其他数据库一样
create view viewname as select column... from "tablename"
倒~~~给你个格式,最简单的: create view 视图名 as select ... ... from ... ... where ... ...
create view as ... 但没有关联会出迪卡而积
应该有条件关联,不然会有迪卡而积只能给你格式了: create or replace view v_viewname as select column1... from tablename where ...
全格式如下: CREATE VIEW <view_name> [(column1, column2...)] AS SELECT <table_name column_names> FROM <table_name> WITH CHECK OPTION
select DEPARTMENT.DEPARTMENT, -- 科别名称
DEPARTMENT.DEPARTMENTNO, -- 科别号
EXPERT.EXPERTNAME, -- 专家专科姓名
EXPERT.EXPERTNO, -- 专家专科编号
EXPERT.SPECIALITY, -- 专长
EXPERT.SYNOPSIS, -- 简介
EXPERT.TYPENUM, -- 类型号
EXPERT.ZC -- 职称
FROM DEPARTMENT, EXPERT
WHERE ( DEPARTMENT.DEPARTMENTNO = EXPERT.DEPARTMENTNO ) ;
as
select t1.z1,t1.z3,t2.a1,t2.a2,t3.b1,t3.b3,t4.c1,t4.c2,
t5.d1,t5.d3,t6.e1,t6.e2,t7.f1,t7.f3,t8.g1,t8.g2
from
t1,t2,t3,t4,t5,t6,t7,t8
as
select t1.z1,t1.z3 ..........
from t1,...... t8;
as
select .......
as
select .......
同其他数据库一样
as
select column... from "tablename"
create view 视图名
as
select ... ...
from ... ...
where ... ...
但没有关联会出迪卡而积
create or replace view v_viewname as
select column1...
from tablename
where ...
CREATE VIEW <view_name> [(column1, column2...)] AS
SELECT <table_name column_names> FROM <table_name>
WITH CHECK OPTION