oracle常用语句

oracle常用语句

一、oracle中常用排序

1.中文一. 二. 三排序

NLSSORT(yx_mc,‘NLS_SORT=SCHINESE_PINYIN_M’)

2.数字1. 2. 3.
to_number(regexp_substr(bmxs.bmh,’[0-9]*[0-9]’,1))

二、oracle创建表空间、数据库、用户语句

删除表空间
–DROP TABLESPACE IEXAM_GJKSROOT INCLUDING CONTENTS AND DATAFILES;

–删除用户
–drop user GJKSROOT cascade;

–创建表空间
CREATE TABLESPACE IEXAM_GJKSROOT LOGGING DATAFILE ‘D:\ORACLE\DATA\ORCL\db\IEXAM_GJKSROOT.dbf’
SIZE 30M AUTOEXTEND ON NEXT 30M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL

– 创建用户
create user gjksroot identified by sasa123;
– 用户授权
grant connect, resource,dba to gjksroot;

– 数据库授权给用户
alter USER gjksroot IDENTIFIED BY sasa123 DEFAULT TABLESPACE IEXAM_GJKSROOT;