Oracle常用函数记录

1.设置系日期格式

alter session set nls_date_format='yyyy-mm-dd';

2.设置日期语言

alter session set nls_date_lanaguage='american';

3.选择指定日期范围

select * from tablename where date>'yyyy-mm-dd';

select * from tablename where date between 'yyyy-mm-dd' and 'yyyy-mm-dd';

4.打开sql执行时间

set timing on;

5.打开只读事务

set transaction read only;

6.查看用户权限

select * from user_sys_privs;

7.查看用户所拥有的角色

select * from user_role_privs;

8.查看表空间的具体信息

select * from dba_data_files;

9.查看表空间

select * from v$tablespace;