Prevents character translation causing an error. Specifies a special character to escape in a filename. Where system_variable and value represent one of the following clauses:ĪPPI tablename] Įnables recording of SQL, PL/SQL and SQL*Plus errors to an error log table which you can query later.ĭefines the character you enter as the escape character. enable or disable printing of column headings Sets a system variable to alter the SQL*Plus environment settingsįor your current session. You can display all of the set commands running the help set command as follows. When you use the SET commands, result of sql scripts are being readable. SET Commands are used to put into shape in terms of line size, page size and etc. When you use the SQL*Plus tool, you need to use SET Commands to suppress the output from the script. I will explain SQL*Plus Set Commands in Oracle in this post.
0 Comments
Leave a Reply. |