HOW TO APPEND TABLE ON ORACLE DATABASE?

[Former Member]

DEAR ALL,

CAN ANY ONE SUGGEST ME WITH SOME SAMPLE CODE AS TO HOW TO UPDATE AND APPEND TABLE ON ORACLE DATABASE USING SQL.

EXEC SQL.

APPEND TABLE FROM INT-TABLE.

END EXEC.

WILL THIS WORK.

[Former Member]

I think you have to use a loop and a native SQL insert.

Rob

[Former Member]

Check the sample code:

DATA Y TYPE I VALUE 300.

DATA Z TYPE I.

EXEC SQL.

INSERT INTO AVERI_CLNT (CLIENT, ARG1, ARG2, ARG3)

VALUES ('000', 9, 2, 47)

ENDEXEC.

DATA: F1(3), F2(3), F3(3).

F3 = ' 1 '.

EXEC SQL PERFORMING WRITE_AVERI_CLNT.

SELECT CLIENT, ARG1 INTO :F1, :F2 FROM AVERI_CLNT

WHERE ARG2 = :F3

ENDEXEC.

FORM WRITE_AVERI_CLNT.

WRITE: / F1, F2.

ENDFORM.

Check the below link:

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/frameset.htm

Regards,

Prakash.