db2 及oracle查看视图创建语句

db2查看视图创建语句：

SELECT TEXT FROM syscat.views WHERE viewschema='UMS' AND viewname='VIEW_ENT_MIGRATION'

oracle查看表或视图创建语句：

SELECT DBMS_METADATA.GET_DDL('TABLE','DT_MEMBER') FROM DUAL;