Collections:
Show Current SQL*Plus System Settings in Oracle
How To Look at the Current SQL*Plus System Settings in Oracle?
✍: FYIcenter.com
If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise:
SQL> SHOW AUTOCOMMIT autocommit OFF SQL> SHOW HEADING heading ON SQL> SHOW LINESIZE linesize 80 SQL> SHOW PAGESIZE pagesize 14 SQL> SHOW FEEDBACK FEEDBACK ON for 6 or more rows SQL> SHOW TIMING timing OFF SQL> SHOW NULL null "" SQL> SHOW ALL appinfo is OFF and set to "SQL*Plus" arraysize 15 autocommit OFF autoprint OFF autorecovery OFF autotrace OFF blockterminator "." (hex 2e) cmdsep OFF colsep " " compatibility version NATIVE concat "." (hex 2e) copycommit 0 COPYTYPECHECK is ON define "&" (hex 26) describe DEPTH 1 LINENUM OFF INDENT ON echo OFF ...
⇒ SQL*Plus Environment Variables in Oracle
⇐ Change SQL*Plus System Settings in Oracle
2020-07-22, 10670🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...