oracle中创建视图并查询视图

1.创建视图：

CREATE OR REPLACE VIEW TB_CONF AS
SELECT SI.SYSID id,SI.SYS_NAME_EN AS sysName,SI.SYS_NAME_CN AS sysCname,SI.RECEIVE_STATUS AS sysReceiveStatus,
SI.SEND_STATUS AS sysSendStatus,SI.ENCODING AS encoding,
(SELECT SIXSD.VALIDTYPE
FROM TB_SUB_SYS_XSD SIXSD
WHERE SIXSD.SYSID = SI.SYSID) AS xsdValidType,
(SELECT SIXSD.CONTENT
FROM TB_SUB_SYS_XSD SIXSD
WHERE SIXSD.SYSID = SI.SYSID) AS xsdContent
FROM TB_SUB_SYS_CONF SI
WHERE SI.DEL_FLAG = 0

2.查询视图：

SELECT * FROM TB_CONF

查询视图就和查询表一样，只不过是把表名改为视图名就可以了。。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!