mbergeby
asked on
Format Mask for numbers in SQLLoader
I need to give a format mask for numbers in sqlloader
The csv file is cvariable record length and variable column length
Is it possible and how do I do it
The csv file is cvariable record length and variable column length
Is it possible and how do I do it
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Additional Info
The numbers are in the format 123.456.789 and sometimes 123.456
Fields terminated by ;
Data in a separate file which is defined by the infile parameter
The numbers are in the format 123.456.789 and sometimes 123.456
Fields terminated by ;
Data in a separate file which is defined by the infile parameter
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes sure,
You will have to use your own column names and own function (to_number instead of upper).
That was just an example to show you that it works.
You will have to use your own column names and own function (to_number instead of upper).
That was just an example to show you that it works.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Any update on this? If your problem has been resolved, then please close this question.
Any update on this? If your problem has been resolved, then please close this question.
ASKER
I have to ask you to be more specific
Is this an example or is it something I have to do before the actual loading
Can I use the actual column name instead of INSERT_STMT as in your example