oracle常用命令
1.解锁用户alter user scott account unlock;
2.设置主键自增长
1.首先建一个sequencecreate sequence test_seq start with 1 increment by 1 nocycle;2.建一个triggercreate or replace trigger test_seqbefore insert on user_test //table_namefor each rowwhen(new.id is null)beginselect test_seq.nextvalinto :new.id from dual;end;
3.插入日期类型值
insert into table_name(date_cloumn) values(to_date('2012-9-8','yyyy-mm-dd'));
页:
[1]