Table of ContentsPreviousNext

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.

Ispirer SQLWays Database Migration Software

Conversion of DEFAULT values from IBM DB2 to Oracle

Oracle interprets DEFAULT '' as NULL whereas such syntax is interpreted as an empty string in IBM DB2. In order to insert an empty string as the default in Oracle, the syntax must be like DEFAULT ' ' (with the space between single quotes).

SQLWays converts DEFAULT '' from IBM DB2 to Oracle as DEFAULT ' ':

TABLE 100. Conversion of DEFAULT values from IBM DB2 to Oracle
CREATE TABLE table_name1
col1 varchar(10) default `'
CREATE TABLE table_name1
col1 varchar2(10) default ` 

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