sql - Why is this insert statement throwing an expression missing error? -


i using oracle sql. why insert statement throwing expression missing error?

insert t_data(id, object_type, object_id,                           measurement_id, derived_ind, no_hist_ind,                          display_order, stored_precision, display_precision,                          required_ind, mod_user, mod_dtime)                   values(select max(id) + 1 t_data_point, 'object', 'objectname',                          'id', 3, 0, 1, 2, 2, 0, 'test', sysdate); 

your usage can insert.. into.. select..

insert t_data(id, object_type, object_id,                           measurement_id, derived_ind, no_hist_ind,                          display_order, stored_precision, display_precision,                          required_ind, mod_user, mod_dtime)                   (select max(id) + 1,  'object', 'objectname',                          'id', 3, 0, 1, 2, 2, 0, 'test', sysdate                          t_data_point); 

to use select inside values... embed them in brackets.

values(        (select max(id) + 1 t_data_point),        ...       ) 

edit:

make sure, expression in insert columns , values match.


Comments