oracle卸载运行regedit，删除HKEY_LOCAL_MACHINE\SOFTWARE\ORACLEHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services，滚动 这个列表，删除所有Oracle入口。 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application， 删除所有Oracle入口。-- 创建表空间BwfBookcreate tablespace BwfBookloggingdatafile 'D:\app\Administrator\oradata\orcl\BwfBook.dbf'size 20Mautoextend onnext 10M maxsize 1024Mextent management local;-- 创建临时表空间BwfBook_tempcreate temporary tablespace BwfBook_temptempfile 'D:\app\Administrator\oradata\orcl\BwfBook_temp.dbf'size 20Mautoextend onnext 10M maxsize 1024Mextent management local;-- 创建用户bookAdmin，并指定默认表空间和临时表空间create user bookAdmin identified by bwf123 default tablespace BwfBook temporary tablespace BwfBook_temp;-- 给用户bookAdmin授权grant connect, resource, dba to bookAdmin;select * from tbl_book;insert into tbl_book values (23, '西游记2', '吴承恩', '25.5', default, 1001);select t.*, t.rowid from TBL_BOOK tselect to_char(to_date('2017-3-1', 'yyyy-mm-dd'), 'hh') from dual;select sysdate - to_date('2015-3-1', 'yyyy-mm-dd') from dual;select last_day(sysdate) from dual;select months_between(sysdate, to_date('2017-3-1 23:11:33', 'yyyy-mm-dd hh24:mi:ss') )from dual;select next_day(sysdate, '星期二') from dual;select trunc(to_date('2017-3-9 21:09:13', 'yyyy-mm-dd hh24:mi:ss')) + (interval '2:23:15' hour to second) from dual;select NVL('zhangsan@qq.com', '暂无') from dual;select sum(bprice) from bookAdmin.tbl_book;select * from myemp;create synonym myemp for scott.emp;drop synonym myemp;create sequence seq_teststart with 10000increment by 1;select seq_test.currval from dual;create trigger trig_book_ai before insert on tbl_book for each rowbegin  select seq_test.nextval into :new.bid from dual;end;