What does exactly do the command “REM INSERTING into TABLE_NAME” in Oracle?

REM, or short for REMARK, is used in SQL*Plus to indicate the beginning of a comment in a SQL script. Read more about REM in the documentation here.

Instead of

 REM INSERTING into TABLE_NAME 

I suggest you use PROMPT

 PROMPT INSERTING into TABLE_NAME 

That way the script output would contain the string “INSERTING into TABLE_NAME”.

More about PROMPT here. It’s especially useful when you have ECHO OFF.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)