Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

[Oracle] Subsection

This subsection is used to adjust script generations when Oracle is the target database, and to specify properties when it is the source database.

If No is specified, the TO_DATE function is not generated in SQL INSERT statements. Possible values - Yes, No. The default value is Yes.

If any value is specified in the DATE_FORMAT option in the [Data] subsection, it overrides the DATE option.

If any value is specified in the TIME_FORMAT option in the [Data] subsection, it overrides the TIME option.

If any value is specified in the DATETIME_FORMAT option in the [Data] subsection, it overrides the TIMESTAMP option.

If you what to load fields that contain only blanks into CHAR NOT NULL columns and the text file has the fixed length format, you have to use DECODE function, because SQL Loader treats blanks as NULLs. Set this option to Yes and SQLWays will generate DECODE function to convert NULLs to blanks.

To specify Oracle options using the SQLWays wizard


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.