oracle查询默认表,Oracle 基础温习2 查询默认表空间及其下面的table

请输入用户名:  starive

输入口令:

连接到:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> select default_tablespace from user_users where username='starive';

未选定行

###查询当然默认的表空间

SQL> select default_tablespace from user_users;

DEFAULT_TABLESPACE

------------------------------------------------------------

STARIVESPACE

###在默认表空间下创建 数据库里面三个典型的表

SQL> create table student( sno char(9) primary key,

2  sname char(20) not null,

3  ssex char(4),

4  sage smallint,

5  sdept char(20));

表已创建。

SQL> select table_name from all_tables where tablespace_name='starivespace';

未选定行

###查询刚刚创建的表是否在默认表空间

SQL> select table_name from all_tables where tablespace_name='STARIVESPACE';

TABLE_NAME

------------------------------------------------------------

STUDENT

###继续后面的3张表的工作

INSERT INTO Student VALUES('0201','赵伟','男',18,'cs');

INSERT INTO Student VALUES('0202','张力虹','男',19,'is');

INSERT INTO Student VALUES('0203','徐秀美','女',21,'is');

INSERT INTO Student VALUES('0204','刘平','男',20,'cs');

INSERT INTO Student VALUES('0205','姚家全','男',19,'cs');

INSERT INTO Student VALUES('0206','上关美云','女',23,'ma');

create table course(

cno CHAR(6),

cname varchar2(20),

credit number,

primary key(cno)

) tablespace starivespace;                    ---》此时写不写表空间都可以，因为默认已是starivespace

INSERT INTO course VALUES('0001','高等数学',6);

INSERT INTO course VALUES('0002','离散数学',2);

INSERT INTO course VALUES('0003','大学物理',4);

INSERT INTO course VALUES('0006','算法语言',2);

CREATE TABLE SC

(Sno    CHAR(9)  NOT NULL,

Cno    CHAR(6)  NOT NULL,

Grade    SMALLINT,

PRIMARY KEY (Sno,Cno),

constraint f1 FOREIGN KEY (Sno) REFERENCES Student(Sno),

FOREIGN KEY (Cno) REFERENCES Course(Cno)

)  tablespace starivespace;

SQL> select table_name from all_tables where tablespace_name='STARIVESPACE';

TABLE_NAME

------------------------------------------------------------

STUDENT

COURSE

SC