某个时间的值
select * from table as of timestamp to_timestamp('2019-2-15 13:47:50','yyyy-mm-dd hh24:mi:ss') where
使用escape关键字去转义特殊字符
select * from table where TEST_POINT like 'version_\'||'%' escape '\';
replace 表中值
update table set name = replace(name,'name_','') where name like 'name_%';--替换
把name中出现'name_'的全部替换为''
增加更新时间字段
ALTER table t_peauge_http_sysInfo add column `CREATE_TIME` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间';
ALTER table t_peauge_http_sysInfo add column `UPDATE_TIME` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '更新时间'
插入多条数据
declare
v_order_id VARCHAR2(8);
v_order_date VARCHAR2(10);
i int;
begin
i:=1001;
v_order_id :='111111';
v_order_date :='20190909';
for i in 1001..1002 loop
insert into table (order_id,order_date) values(to_char(v_order_id +i),to_char(v_order_date +i))
end loop;
commit;
end;
SEQUENCES
SHOW SEQUENCES where name = 'mer_id_seq'
UPDATE SEQUENCES set value='1518593' where name = 'mer_id_seq'