Rules for comments usage in oracle database scripts while using TRI2 Migration Tool

Post date: Jul 28, 2017 5:58:27 AM

TRI2 Migration Tool internally using sqlplus utility to migrate oracle database scripts.

Please find the below notes on placing comments while attaching sql script for migration through TRI2 migration Tool.

Notes on Placing Comments

SQL*Plus does not have a SQL or PL/SQL command parser. It scans the first few keywords of each new statement to determine the command type, SQL, PL/SQL or SQL*Plus. Comments in some locations can prevent SQL*Plus from correctly identifying the command type, giving unexpected results. The following usage notes may help you to use SQL*Plus comments more effectively

• 1. Do not put comments after statement terminators (period, semicolon or slash). For example, if you enter:

     1. SELECT 'Y' FROM DUAL; -- TESTING 

     2. You get the following error:

• • 1. SQL*Plus expects no text after a statement terminator and is unable to process the command.

• 1. Do not put statement termination characters at the end of a comment line or after comments in a SQL statement or a PL/SQL block. For example, if you enter:

     1. SELECT * -- COMMENT; 

     2. You get the following error:

• • 1. Note: Please follow the Placing Comments in Scripts link for more information.