1.sequene值不能放在子查詢中。
2.max值要以虛擬table方式產出。
範例:
insert into table_x_params(objid, x_action, x_parameter, x_value, x_sequence)
select (seq_x_params.nextval ),'210','book_id','default',mseq From (select max(x_sequence)+1 as mseq from table_x_params);
