一、视图创建代码注释说明
Oracle
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
CREATE VIEW
:创建视图的语法关键字;view_name
:视图的名称;SELECT
:查询关键字;column1, column2, ...
:需要查询的列名;FROM
:查询来源;table_name
:查询的表名;WHERE
:查询条件;condition
:查询的条件。
MySQL
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
CREATE VIEW
:创建视图的语法关键字;view_name
:视图的名称;SELECT
:查询关键字;column1, column2, ...
:需要查询的列名;FROM
:查询来源;table_name
:查询的表名;WHERE
:查询条件;condition
:查询的条件。
SQL Server
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
CREATE VIEW
:创建视图的语法关键字;view_name
:视图的名称;SELECT
:查询关键字;column1, column2, ...
:需要查询的列名;FROM
:查询来源;table_name
:查询的表名;WHERE
:查询条件;condition
:查询的条件。
PostgreSQL
CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;
CREATE VIEW
:创建视图的语法关键字;view_name
:视图的名称;SELECT
:查询关键字;column1, column2, ...
:需要查询的列名;FROM
:查询来源;table_name
:查询的表名;WHERE
:查询条件;condition
:查询的条件。
二、多表视图创建的写法及结果
Oracle
以下是在Oracle数据库中创建多表视图的示例代码:
-- 建立部门表
CREATE TABLE department (
dept_id NUMBER(10) PRIMARY KEY,
dept_name VARCHAR2(50) NOT NULL
);
-- 插入数据
INSERT INTO department VALUES (1, '部门1');
INSERT INTO department VALUES (2, '部门2');
INSERT INTO department VALUES (3, '部门3');
-- 建立员工表
CREATE TABLE employee (
emp_id NUMBER(10