Sumit Prakash
asked on
insert query for multiples orderid
Hello Team,
Can you please help me in inserting below query with n number of OrderId at a time. Below is query for single order insert statement.
INSERT
INTO OMS_ORDER_MILESTONE
(
ORDMILESTONE,
CREATED_DATE,
COMPLETED_DATE,
CWDOCID,
CWORDERID
)
VALUES
(
'10',
sysdate,
sysdate,
'orderId', --Internal OrderId
'orderId' --Internal OrderId
);
COMMIT;
Can you please help me in inserting below query with n number of OrderId at a time. Below is query for single order insert statement.
INSERT
INTO OMS_ORDER_MILESTONE
(
ORDMILESTONE,
CREATED_DATE,
COMPLETED_DATE,
CWDOCID,
CWORDERID
)
VALUES
(
'10',
sysdate,
sysdate,
'orderId', --Internal OrderId
'orderId' --Internal OrderId
);
COMMIT;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you provide a little more detail on what you're trying to accomplish? As an example, if you are trying to insert records for n orderids and n equals five, what would you expect the oms_order_milestone table to look like?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you been able to confirm either of the answers? If so, can you choose an answer as a solution to close this question? If not, then please give feedback explaining what is not working so we can help you further.
Any of the above solutions will work. I awarded the first solution as the Best Solution.