create users and grant privilages

--drop table users


--            drop tablespace javatest


create tablespace javatest datafile 'd:\oracle\javatest.dbf' size 2000M;


--grant connect ,resource to jiumao;


alter user jiumao default tablespace javatest;




create table users 
(
userid int not null , 
username  varchar2(50),
userno varchar2(50),
creationdate date,
createdby varchar2(50)
)
tablespace javatest ;


create sequence users_pk_seq 
minvalue 1
maxvalue 99999999999
increment by 1
cache 20




insert into users values(users_pk_seq.nextval, 'Aaron' , '6688', sysdate, '')


select  u.*
from users u 


create trigger trigger_users_id 
before insert on users
for each row