Run SQL Code Block with Variables in Oracle SQL Developer
DECLARE p_cart_id NUMBER:= 125330; p_cart_item_id NUMBER; BEGIN FOR i IN 1..200 LOOP — get next sequence p_cart_item_id := tbl_cart_item.NEXTVAL; –insert new line from select INSERT INTO TBL_CART_ITEM(cart_item_id,cart_id,item,qty, line_no) SELECT t.* FROM ( SELECT...