ITPub博客

http://blog.csdn.net/tianlesoftware/article/details/5689558

--undoselect * from user_tables where table_name='T%';create table t(id int,name varchar2(10)) tablespace testtbs;insert into t values(2,'b')commitupdate t set name='c' where id=1;--没有提交--再打开另...

一、创建用户select * from dba_users;select * from all_users;select * from user_users;create user  test1 identified by test1；指定缺省表空间：create user test2 identified by test2 default tab...

一、条件判断：if     。。。。 then  end if；  if  。。。then    else          。。。。；  &nbs...

查看表空间：select * from dba_tablespaces；创建表空间：create tablespace testtbs1 datafile 'c:\oradata\mail\testtbs1.dbf' size 5m;扩展表空间中的数据文件到多大：alter database datafile 10 resize 1...