Lucas_wei的博客

sys免密登陆sqlplus “/as sysdba”（在windows操作平台下）sqlplus sys/change_on_install as sysdba但如果是sys用户，密码必须加上as sysdba，即完整密码为：change_on_install as sysdba解锁systemalter user system account unlock;查询...

创建序列INCREMENT BY 1 START WITH 1 NOMAXvalue NOCYCLE NOCACHE;执行插入语句（序列的使用）insert into noteuser (user_id,name,gender,age,area) values(noteuser_seq.nextval,‘green’,‘male’,18,‘beijing’);删除序列drop ...