-
External Tables - Numeric Conversion
Hi all,
i have an external table definition which works fine with floats as long as they got a dot for the decimal place.
If they got a comma they get rejected. But those files are exported by Oracle as flat files. Can i adjust the export to do it right or can i do a number conversion like i can do with the SQL Loader?
(TO_NUMBER does not work :-( )
Thanks alot
/F#
-
Re: External Tables - Numeric Conversion
Originally posted by SteinLaus
Hi all,
i have an external table definition which works fine with floats as long as they got a dot for the decimal place.
If they got a comma they get rejected. But those files are exported by Oracle as flat files. Can i adjust the export to do it right or can i do a number conversion like i can do with the SQL Loader?
(TO_NUMBER does not work :-( )
Thanks alot
/F#
if you can do it in sql*loader I think you can dql sqlldr contrl.ctl external_table=generate or something like that and it will work out the create table statement for you
-
eh, what's that Davey.... sounds interesting, can you enlighten me
-
Originally posted by Horace
eh, what's that Davey.... sounds interesting, can you enlighten me
http://asktom.oracle.com/pls/ask/f?p...30572233529536
-
ooooooh! I like that! That's good that is........
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|