Can SQL operators be used in EXTERNAL TABLE definitions like in SQLLDR
Hello,
I am not sure about he possbility for use and also the syntax.
Is allowed to use sql operators in access parameter definitions of external table definitions where sqlldr driver is used?
Is the syntax presented in below definiton example ok?
The idea is to translate from source code page to the database destination code page.
create table MKB_CSV1 (
Text varchar2(491)
)
organization external (
type oracle_loader
default directory DUMPDIR
access parameters (
records delimited by newline
fields (
Text position(1:491) char( 491 )
"convert( :Text, 'AL32UTF8', 'EE8MSWIN1250' )"
)
)
location ("DUMPDIR":'mkb_10_am-v6_v02_CSV.csv')
)
reject limit unlimited;
Thank you for suggestion/correction/any info.