alter table NST_GOOD modify CREATE_TIME DATE default sysdate;
4、获取字符占的长度
select lengthb('中国') from dual;
二、获取过去时间的数据
1、获取某个时间的数据
SELECT * FROM table_name AS OF TIMESTAMP TO_TIMESTAMP('2023-07-18 10:00:00', 'YYYY-MM-DD HH24:MI:SS');
2、将数据库数据回滚到之前某个时间段
alter table AABBC enable row movement
flashback table AABBC to timestamp to_timestamp('2023-01-17 14:10:00','yyyy-mm-dd hh24:mi:ss')
alter table AABBC disable row movement
三、序列
1、创建序列
create sequence NST_SEQ
increment by 1
start with 1
nomaxvalue
nominvalue
cache 20;
2、查询序列
select * from user_sequences where sequence_name = 'NST_SEQ';