xyq.zip_oracle_php oracle_xyq92968163.com

1、新建表空间 create tablespace tp_XYQ datafile 'G:\OracleProjects\xyq.dbf' size 100m autoextend on next 20m; 2、新建开发者账户： create user xyqs identified by xyqs default tablespace tp_XYQ quota unlimited on tp_XYQ; 3、给新建用户授权： grant connect,resource to xyqs; grant create session,create table,create trigger,create procedure to xyqs; 4、连接新用户 conn xyqs/xyqs; 5、新建所需的表： create table wish (wID int primary key, wFrom varchar2(20) not null, wTo varchar2(30) not null, wish varchar2(200) not null, wTime date default sysdate, wStyleIndex int not null, wImageIndex int not null); 6、建立序列 数据自增 create sequence seq_wish maxvalue 999999 start with 1 increment by 1; 7、建立触发器 数据自增 create or replace trigger tri_wish before insert on wish for each row begin select seq_wish.nextval into :new.wid from dual; end; / 8、测试数据插入： insert into wish(wFrom,wTo,wish,wStyleIndex,wImageIndex) values('zhangsan','lisi','Have a good time!',3,7); commit;