1。创建SEQUENCE
create sequence seq_id increment by 1 start with 1 maxvalue 999999999;
insert into tbname values(seq_id.nextval,...);
2.select sysdate from dual;
3.select substr('123456',1,5) from dual;
create sequence seq_id increment by 1 start with 1 maxvalue 999999999;
insert into tbname values(seq_id.nextval,...);
2.select sysdate from dual;
3.select substr('123456',1,5) from dual;
----------
24-9月 -04如果我要的是2004-09-24 或mm/dd/yyyy 、mm-dd-yy、dd mon yyyy hh:mm:ss:mmm、yyyy-mm-dd hh:mm:ss
怎么办??
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
select to_char(sysdate,'yyyyww') from dual;
.....