oracle数据库学习

select * from all_tables where table_name not in (select table_name from user_tables);

select * from user_tables;

select * from dept  order by deptno desc;

select * from emp  order by empno desc;

alter table emp add GENDER nchar(6);
alter table emp add COMMENTS VARCHAR2(1000);
ALTER TABLE EMP ADD PHOTO BLOB;

update  emp
set gender='0';


CREATE  TABLESPACE  NNC_DATA01  DATAFILE  'D:\Oracle\oradata\nnc_data01.dbf'  SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ; 
CREATE  TABLESPACE  NNC_DATA02  DATAFILE  'D:\Oracle\oradata\nnc_data02.dbf'  SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE  TABLESPACE  NNC_DATA03  DATAFILE  'D:\Oracle\oradata\nnc_data03.dbf'  SIZE 200M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;
CREATE TABLESPACE NNC_INDEX01 DATAFILE 'D:\Oracle\oradata\nnc_index01.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ; 
CREATE TABLESPACE NNC_INDEX02 DATAFILE 'D:\Oracle\oradata\nnc_index02.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ; 
CREATE TABLESPACE NNC_INDEX03 DATAFILE 'D:\Oracle\oradata\nnc_index03.dbf' SIZE 200M AUTOEXTEND ON NEXT 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE  USER  nc57uap(用户名)  IDENTIFIED  BY  nc57uap(密码)  DEFAULT  TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;  --创建用户
GRANT connect,dba(连接数据库) to nc57uap; --授权用户 nc57uap

Microsoft Windows [版本 6.3.9600]
(c) 2013 Microsoft Corporation。保留所有权利。

C:\Users\百林>sqlplus