Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sql loader passing dynamic values issue

selvi mDec 1 2022

hello, Team
I created control scripts in which the first two values(COUNTRY AND SUB_DIV) came from dynamic passing at run time and the next two values came from a dat file. I have run the control file i face issue .
Please assist me with this issue by first showing me how to pass and load data into a table.

scripts :

LOAD DATA
REPLACE
INTO TEAM_ADD_DETAILS
TRAILING NULLCOLS
(
COUNTRY POSTION(0:0) "&&1",
SUB_DIV POSTION(0:0) "&&2",
S_NUMBER POSTION(1:10) INTEGER EXTERNAL(10),
S_VALUES POSTION(11:14) INTEGER EXTERNAL(4)
)
This post has been answered by Solomon Yakobson on Dec 2 2022
Jump to Answer

Comments

Processing

Post Details

Added on Dec 1 2022
#plsql, #sql, #sqldeveloper, #sqlplus
4 comments
344 views