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
Post a Comment