在Oracle SQL插入语句中返回参数

您需要将其放入PL / SQL块中：

declare  videoID number;begin  insert into VM_VIDEO (VIDEO_ID, ...)    values (SEQ_VMMIGVIDEO_ID.NEXTVAL, ...)    returning VIDEO_ID into videoID;  insert into IMAGES (IMAGE_ID, ...)    values (SEQ_IMAGE_ID.NEXTVAL, ...);  update VM_VIDEO    set THUMB_IMAGE_ID = SEQ_IMAGE_ID.CURRVAL    where VIDEO_ID = videoID;end;