CREATE OR REPLACE VIEW V_CREDIT_HEIMINGDAN AS SELECT T.ZTMC,T.ZTNAME,T.SXXWJK,T.XXBSJG,T.NRLY,T.LRSJ FROM ( SELECT A.OBJECT_NAME AS ZTMC,'涉金融领域严重失信企业名单' AS ZTNAME,'' AS SXXWJK,'' AS XXBSJG,'' AS NRLY,TO_CHAR(A.PUT_IN_DATE, 'YYYY-MM-DD') AS LRSJ FROM t_xxx A WHERE A.OBJECT_NAME=P_VIEW_PARAM.GET_ZTMC_DISHONESTY() AND A.DATA_SOURCES='G' AND A.IDENTIFICATION != 'D' UNION ALL视图怎么根据查询条件查询数据查询数据
时间: 2024-01-08 14:03:21 浏览: 29
你可以在 SELECT 子句后添加 WHERE 子句来根据查询条件查询 V_CREDIT_HEIMINGDAN 视图的数据,例如:
```
SELECT * FROM V_CREDIT_HEIMINGDAN WHERE ZTMC = 'ABC公司' AND NRLY = '失信被执行人名单';
```
这将返回 ZTMC 为 'ABC公司',NRLY 为 '失信被执行人名单' 的记录。你可以根据实际的查询条件进行修改。
相关问题
CREATE OR REPLACE VIEW V_CREDIT_HEIMINGDAN AS SELECT T.ZTMC,T.ZTNAME,T.SXXWJK,T.XXBSJG,T.NRLY,T.LRSJ FROM ( SELECT A.OBJECT_NAME AS ZTMC,'涉金融领域严重失信企业名单' AS ZTNAME,'' AS SXXWJK,'' AS XXBSJG,'' AS NRLY,TO_CHAR(A.PUT_IN_DATE, 'YYYY-MM-DD') AS LRSJ FROM t_xxx A WHERE A.OBJECT_NAME=P_VIEW_PARAM.GET_ZTMC_DISHONESTY() AND A.DATA_SOURCES='G' AND A.IDENTIFICATION != 'D' UNION ALL视图怎么查询数据
你可以使用以下 SQL 语句查询 V_CREDIT_HEIMINGDAN 视图的数据:
SELECT * FROM V_CREDIT_HEIMINGDAN;
请注意,这里的 V_CREDIT_HEIMINGDAN 视图是根据你提供的信息进行假设的,实际上可能并不存在。如果你需要查询其他视图,请将视图名称替换为实际的名称。
相关推荐
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![docx](https://img-home.csdnimg.cn/images/20210720083331.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![7z](https://img-home.csdnimg.cn/images/20210720083312.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)