| field description [message #71476] |
Fri, 08 November 2002 11:44  |
Koos Post
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
Hello guys and girls, please help me.
I'm just beginning with oracle, being confronted with
the following problem making the ctl.file.
The database contains ä table with one single field, let say, why not, money : datatype number(8,2).
The input file is variable of length, contains the
delimiter |, for example :
54123.45
34.20|
it's in the input file regarded as dec(8,2); the unload-specification from an informix-database.
how to make the field specification ?
money integer ?
money dec(8,2) ?
maybe with zones ?
I've tried several things, but it didnt work out.
So, if you have a good suggestion, mail me.
The last question : do you know a website with fabulous
Well, that's it.
I want to excuse me for my poor knowledge, as i said before, i'm no pro, not at all. Just beginning,
with friendly regards from the netherlands,
Koos
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
