插入数据 oracle,oracle插入数据

插入数据

insert into comm_error_code_def (ID, ERR_MESSAGE, ERR_CODE, ERR_DESC, NAME, MISC_DESC, STATUS, CREATE_TIME, CREATE_OPER_ID, CREATE_OPER_NAME, UPDATE_TIME, UPDATE_OPER_ID, UPDATE_OPER_NAME)

values (seq_comm_error_code_def_id.nextval, 'message.check.error', '2079', '失败 ', '失败 ', '失败 ', 'V', to_date('31-01-2013 13:01:20', 'dd-mm-yyyy hh24:mi:ss'), '1', '系统管理员', to_date('31-01-2013 13:01:20', 'dd-mm-yyyy hh24:mi:ss'), '1', '系统管理员');

insert into comm_error_code_convert c (c.ID,

c.ERROR_ID,

c.CONVERT_CODE,

c.CONVERT_DESC,

c.NAME,

c.MISC_DESC,

c.STATUS,

c.CREATE_TIME,

c.CREATE_OPER_ID,

c.CREATE_OPER_NAME,

c.UPDATE_TIME,

c.UPDATE_OPER_ID,

c.UPDATE_OPER_NAME)

select seq_comm_error_code_convert_id.nextval, t.id,

'C1',

'失败',

'失败',

'descDesc',

'V',

to_date('09-07-2013 11:10:11', 'dd-mm-yyyy hh24:mi:ss'),

'-1',

'procedure',

to_date('09-07-2013 11:10:11', 'dd-mm-yyyy hh24:mi:ss'),

'-1',

'procedure'

from comm_error_code_def t where t.err_message='message.check.error' and t.err_code='2079';