【文章內(nèi)容簡介】 ), 單價(jià)oi_remark varchar2(100) default 39。無39。 備注信息)select * from hotel_oinfo order by r_id。drop table hotel_oinfo。delete from hotel_oinfoinsert into hotel_oinfo values(,100000,1000,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100000,1001,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100000,1003,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100001,1005,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100002,1004,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100003,1002,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100004,1007,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100005,1006,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100006,1008,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100007,1009,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100007,1010,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100008,1011,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100009,1012,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100010,1013,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100011,1014,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100012,1015,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100013,1016,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。mit。事務(wù)處理同事插入begin savepoint point1。 insert into hotel_oinfo values(,1000,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。已付款39。,39。無39。)。 insert into hotel_olist values(,hotel_oinfo_id,39。admin39。,39。20130726 12:00:0039。,39。無39。,39。預(yù)定中39。,39。無39。)。 mit。 exception when others then rollback work to savepoint point1。 end。 create sequence hotel_assess_id START WITH 1 序列的開始位置(開始位置不能被修改) INCREMENT BY 1 間隔為 1 MAXVALUE 99999999 最大值 CACHE 30 緩存 NOCACHE （沒有緩存） NOCYCLE 不循環(huán) CYCLE（循環(huán)） drop sequence hotel_assess_id。（用于保存客戶點(diǎn)評）hotel_assesscreate table hotel_assess(a_id number(10) primary key , 留言編號ad_name varchar2(20), 留言客戶名reply varchar(200) , 酒店回復(fù)detail varchar(300) 客戶留言)select * from hotel_assess。drop table hotel_assess。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務(wù)酒店服務(wù)還不錯(cuò)??！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務(wù)酒店環(huán)境真的還不錯(cuò)啊！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。住的很開心！39。)。insert into hotel_assess values(,39。admin39。,39。謝謝您的建議，我們會(huì)努力的！39。,39。訂房有點(diǎn)復(fù)雜！希望能改好些！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務(wù)酒店，整體來說還不錯(cuò)的，以后常來！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。越來越好！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。什么亂七八糟的酒店嗎！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。服務(wù)態(tài)度不怎么好！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務(wù)酒店很給力啊！！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務(wù)酒店很給力啊！哈哈！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。飯菜不給力！39。)。mit。create sequence hotel_notice_id START WITH 1 序列的開始位置(開始位置不能被修改) INCREMENT BY 1 間隔為 1 MAXVALUE 99999999 最大值 CACHE 30 緩存 NOCACHE （沒有緩存） NOCYCLE 不循環(huán) CYCLE（循環(huán)） drop sequence hotel_notice_id。，活動(dòng)信息表 (保存酒店發(fā)布的公告活動(dòng)通知)hotel_noticecreate table hotel_notice(n_id number(10) primary key , 編號n_title varchar2(20) not null, 發(fā)布的題目n_time varchar2(20) not null, 發(fā)布的時(shí)間n_picture varchar2(50) ,n_detailes varchar(500) not null 保存發(fā)布的內(nèi)容)select * from hotel_notice。drop table hotel_notice。insert into hotel_notice values(,39。訂酒店返現(xiàn)金39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。七天暢游暑假39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。幸運(yùn)抽獎(jiǎng)39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。99元特惠房39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。訂酒店返現(xiàn)金39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。七天暢游暑假39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。幸運(yùn)抽獎(jiǎng)39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。99元特惠房39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。訂酒店返現(xiàn)金39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。七天暢游暑假39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。幸運(yùn)抽獎(jiǎng)39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。insert into hotel_notice values(,39。99元特惠房39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動(dòng)情況39。)。mit。create sequence hotel_introduce_id START WITH 1 序列的開始位置(開始位置不能被修改) INCREMENT BY 1 間隔為 1 MAXVALUE 99999999 最大值 CACHE 30 緩存 NOCACHE （沒有緩存） NOCYCLE 不循環(huán) CYCLE（循環(huán)） drop sequence hotel_introduce_id。11,酒店介紹信息create table hotel_introduce(i_id number(10) primary key, 編號i_title varchar2(100), 標(biāo)題i_detail varchar2(800), 詳細(xì)介紹i_remark varchar2(200) 備注)select * from hotel_introduceselect count(*) from hotel_introducedrop table hotel_introduceinsert into hotel_introduce values(,39。酒店背景介紹39。,39?？头繉挸?