新版shipping oracle sql语句
[sql] 1.连接：conn system/manager;2.建新用户：create user shipping identified by shipping123;3.授所有权限：grant dba,connect,resource to shipping;4.一个公用的序列create sequence common_seqstart with 1increment by 1minvalue 1maxvalue 9999nocyclenocache5.用户信息表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');