ORACLE语句那些事

ORACLE语句那些事

1.查看所有表空间及表空间大小:

select tablespace_name ,sum(bytes) / 1024 / 1024 as MB　from dba_data_files group by tablespace_name;

2.回滚时间

select *
from COMM.PRICE_ITEM_NAME_DICT as of timestamp to_timestamp(‘2022-04-08 08:40:12’, ‘YYYY-MM-DD HH24:MI:SS’);

3.更新数据

update 表名 a set a.字段=‘新数据’ where a.字段=‘原数据’;

4.查询用户密码

select comm.descript(password) from 员工表 a where a.员工编号=‘0000’

5.登录sys用户 授权语句

grant select on sys.v_$session to INPADM;