sql语句的应用

mySql中查询所有视图中是否涉及某张表
SELECT *
FROM information_schema.views WHERE VIEW_DEFINITION like '%表名%'

MySQL中查询所有表中涉及的某个字段

SELECT table_schema ,table_name   
FROM information_schema.columns WHERE column_name = '字段'

MySQL中查询所有存储过程中涉及的某个字段或表或者视图

SELECT *
FROM information_schema.Routines WHERE ROUTINE_DEFINITION like '%想要查询的字段或表或者视图%'

Oracle查询所有表中涉及的某个字段

SELECT
        TABLE_NAME
    FROM
        user_tab_columns
    WHERE
        COLUMN_NAME = '字段'

Oracle数据回滚到某一时段

create table T_INBOUND_COPY_20220708_3 as select * from T_INBOUND_COPY as of timestamp to_timestamp('2022-07-08 11:18:00','YYYY-MM-DD hh24:mi:ss') where 1=1