Link to home
Start Free TrialLog in
Avatar of Sumit Prakash
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;
ASKER CERTIFIED SOLUTION
Avatar of Jim Riddles
Jim Riddles
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.