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, 10219👍, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...