查询数据库对象(表,存储过程等)什么时候被修改过
-- 查询最后修改的对象
SELECT object_name,CREATED,LAST_DDL_TIME from user_objects order by last_ddl_time desc;
SELECT object_name,CREATED,LAST_DDL_TIME from user_objects order by created desc;
数据库数据被删掉,恢复删掉的数据
--数据库恢复
insert into sys_user_t value(
select * from sys_user_t as of timestamp to_timestamp('2019-10-17 10:20:00','yyyy-mm-dd hh24:mi:ss'))
oracle查询数据库编码
-- 编码
select userenv('language')from dual
设置本地环境变量
环境变量名:NLG_LANG
环境变量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK