新学到的sql语句

select t.* from t_b_oilbox_definition t;

DELETE  t_b_oilbox_definition
WHERE id=104;

select t.*, t.rowid from t_b_oilbox_definition t;

insert into t_b_oilbox_definition (id,name,capacity,available,updated_by,updated_time) 
values 
(104,'东风--390L油箱',390,1,1, to_date('2015/10/31 10:40:59' , 'yyyy/mm/dd hh24:mi:ss'));

update t_b_oilbox_definition set id=103
where name='重汽--360L油箱';
//解锁
select lo.OBJECT_ID,o.object_name,s.SID,s.USERNAME,s.COMMAND,s.SERIAL# from v$locked_object lo ,dba_objects o ,v$session s 
where lo.SESSION_ID = s.SID
and o.object_id = lo.OBJECT_ID;


alter system kill session '25,7';
//删除
delete t_b_oilbox_definition