ORACLE學(xué)習(xí)筆記-新建用戶及建表篇

create user SA identified by 2013;

/*授權(quán)connect,resource給用戶sa*/
grant connect,resource to sa;

/*查詢所有的用戶*/
select * from all_users;

/*將表STU查詢權(quán)限授予SA*/
GRANT SELECT ON STU TO SA

/*將表STU添加權(quán)限授予SA*/
GRANT INSERT ON STU TO SA

/*將表STU更新權(quán)限授予SA*/
GRANT UPDATE ON STU TO SA

/*將表STU刪除權(quán)限授予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;

/*創(chuàng)建約束，設(shè)置主鍵*/

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