Database Utilities (MOSC)

MOSC Banner

Can SQL operators be used in EXTERNAL TABLE definitions like in SQLLDR

edited Jan 27, 2015 3:15AM in Database Utilities (MOSC) 5 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center