-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Can anyone spot the error in this attempted data load? The '\\N' is because this is an import of an OUTFILE dump from mysql, which puts \N for NULL fields.
The decode is to catch cases where the field might be an empty string, or might have \N.
Using Oracle 10g on Linux.
load data
infile objects…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have shell script calling Sql*loader utility which inturn uses username/password as arguments. This details cannot be stored on server in any form due to security related policies. i got 2 approaches to handle this situation,
1. create hidden parameter file with login details and limit the access…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi folks.
Here's the problem:
I have a project that needs to be migrated to Microsoft SQL Server 2008.
We have data in text files for the Oracle SQL Loader and now we need to get that data into the SQL Server DB.
I could write a program that converts everything into INSERT statements but there…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I just wonder if you know where to find a tutorial or samples of a Ruby script using sql *loader?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I am using SEQUENCE keyword in SQL Loader control file to generate primary keys. But for a special scenario I would like to use Oracle sequence in the control file. The Oracle documentation for SQL Loader doesn't mentioned anything about it. does SQL Loader support it?
>>> More