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

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