I'm trying to import a CSV file to an existing Oracle (v19c) table and I want to set a couple of columns to fixed values like:
- “some string”
- SYSDATE (Oracle pseudo-function for the current date/time)
The first row of the CSV file has the column names, and I've checked that option in DataGrip.
Then I edited the table column mapping, replacing the pre-selected CSV column name with the fixed value.
Datagrip loads the records, and reports no errors, but the table column value is always NULL.
I've tried surrounding the string value with nothing, single quotes (Oracle's standard) and double quotes. But the result is always the same; the table column is NULL.
And trying to use the SYSDATE function in a date field causes DataGrip to raise a system error, without saving any rows.
Is this possible, or does the CSV file layout have to match the database table definition exactly?