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 09:03:21 浏览: 28
你可以使用以下 SQL 语句查询 V_CREDIT_HEIMINGDAN 视图的数据:
SELECT * FROM V_CREDIT_HEIMINGDAN;
请注意,这里的 V_CREDIT_HEIMINGDAN 视图是根据你提供的信息进行假设的,实际上可能并不存在。如果你需要查询其他视图,请将视图名称替换为实际的名称。