Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change field position value in external table using external modify

Kitchanunt NithinanMay 9 2025 — edited May 9 2025

This when I created external loader.

Sorry bad English I try to read about this as much, but I really don't see information about.

ORGANIZATION EXTERNAL (

TYPE ORACLE\_LOADER

DEFAULT DIRECTORY DATA\_DIR

ACCESS PARAMETERS (

    RECORDS DELIMITED BY NEWLINE

    FIELDS(

        record\_type POSITION(1:1) char,

        data POSITION(8:256) char,

    )

)

LOCATION ('new\_report\_1m.txt')

) REJECT LIMIT UNLIMITED;

and I want to change those fields by external modify

select * from pma_ext_settlement_report external modify (
ACCESS PARAMETERS (
FIELDS(
record_type POSITION(1:1) char,
data POSITION(8:256) char,
trans_id POSITION(XX:XX) char
)
)
LOCATION ('new_report_1m.txt');
);

But it can't be executed, I don't know if it capable to do this. Thank you so much.

This post has been answered by Solomon Yakobson on May 9 2025
Jump to Answer
Comments
Post Details
Added on May 9 2025
2 comments
181 views