ORACLE学习笔记-新建用户及建表篇

create user SA identified by 2013;

/授权connect,resource给用户sa/
grant connect,resource to sa;

/查询所有的用户/
select  from all_users;

/将表STU查询权限授予SA/
GRANT SELECT ON STU TO SA

/将表STU添加权限授予SA/
GRANT INSERT ON STU TO SA

/将表STU更新权限授予SA/
GRANT UPDATE ON STU TO SA

/将表STU删除权限授予SA/
GRANT DELETE ON STU TO SA

/建表指定表空间/
create table KC(KC_NO varchar2(10) not null,KC_NAME varchar2(50) not null) tablespace TEST;

create table STU(STU_ID varchar2(10) not null,STU_NAME varchar2(50) not null,STU_AGE number(2) not null,STU_SET number(2) not null,

KC_NO varchar2(10) not null) tablespace TEST;

/创建约束，设置主键/

ALTER TABLE STU ADD PRIMARY KEY(STU_ID) 

ALTER TABLE KC ADD PRIMARY KEY(KC_NO) 

/查看表空间的表/
Select table_name, tablespace_name from dba_tables where tablespace_name='TEST'

/查询所有的表/
select table_name,tablespace_name,temporary from user_tables