新版shipping oracle sql语句

1.连接：

conn system/manager;

2.建新用户：

create user shipping identified by shipping123;

3.授所有权限：

grant dba,connect,resource to shipping;

4.一个公用的序列

create sequence common_seq
start with 1
increment by 1
minvalue 1
maxvalue 9999
nocycle
nocache

5.用户信息表

create table setting_user (
id number(4),
num varchar2(50),
passwd varchar2(50),
branch varchar2(255),
loginIP varchar2(20),
input date default sysdate
);


insert into setting_user (id,num,passwd,branch) values(common_seq.nextval,'21010','21010123123','test');