![]() ![]() ![]() |
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 ' ':
![]() ![]() ![]() |