Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
Small fix to remove the table alias from the column alias after a TRIM function being applied to the column (fix for Issue #1791).
Using the table alias when referencing the column in the SELECT statement and more specifically in the TRIM function is fine (and often necessary). It's only in the the creation of the table alias (after the AS keyword) that the table alias cannot be used.
Additional details of problem described in Issue #1791.
darold
commented
4 weeks ago
Small fix to remove the table alias from the column alias after a
TRIMfunction being applied to the column (fix for Issue #1791).Using the table alias when referencing the column in the
SELECTstatement and more specifically in theTRIMfunction is fine (and often necessary). It's only in the the creation of the table alias (after theASkeyword) that the table alias cannot be used.Additional details of problem described in Issue #1791.