topic Re: Insert multiple records into tables using native sql in Application Development and Automation Discussions

Insert multiple records into tables using native sql

former_member187732 — Mon, 25 Feb 2013 18:08:52 GMT

Hello guys,

Please help. We are using ORACLE DATABASE as backend.

1. I am selecting multiple records from SAP tables and want to insert records using NATIVE SQL, How can I do that any sample code?

2. We have created tables directly in ORACLE therefore using NATIVE SQL. These tables are not part of the SAP instance.

Please help with sample code. Any help will be appreciated.

Thanks,

James

RaymondGiuseppi — Mon, 25 Feb 2013 18:18:47 GMT

First read some documentation like Native SQL in help.sap.com, also

Regards,

Raymond

Former Member — Mon, 25 Feb 2013 19:05:06 GMT

Hi,

Plesae refer to the below link.Hope its helpful for u.

Regards,

Santanu Mohapatra

former_member187732 — Mon, 25 Feb 2013 19:47:31 GMT

Thanks for the information.

Former Member — Mon, 08 Jul 2013 08:12:20 GMT

Hi Jim,

General way inserting data using Native SQL is

EXEC SQL.

INSERT INTO <TABLENAME> (<FIELD1>, <FIELD2>, <FIELD3>)

VALUES (<VALUE1>,<VALUE3><VALUE3>)

ENDEXEC.

Since in your case there is a internal table we require to loop at the table into work area, and the content of the work area is passed to the value.

LOOP it_tab1 into wa_itab1.

INSERT INTO <TABLENAME> (<FIELD1>, <FIELD2>,....<FIELDN>)

VALUES (:wa_itab1-field1,:wa_itab1-field2,.....:wa_itab1-fieldN)

ENDEXEC.

ENDLOOP.

Also refer to below link