【Oracle】常用SQL
1.创建用户
create
user
GZCS identified
by
123456;
grant
connect
,resource,dba
to
GZCS
;
2.查询当前用户,表清单
select table_name from dba_tables where owner='GZCS'
3.创建数据表空间
create tablespace GZCS datafile 'E:\oracle\product\10.2.0\oradata\orcl\stbss_temp01.dbf' size 100m autoextend on next 32m maxsize 2048m
4.查看数据库编码
select * from nls_database_parameters where parameter ='NLS_CHARACTERSET'; select userenv('language') from dual;
5.查看当前数据库
select name from V$DATABASE;
或者
select SYS_CONTEXT('USERENV','INSTANCE_NAME') from dual;