Oracle - Show Current SQL*Plus System Settings in Oracle

Show Current SQL*Plus System Settings in Oracle

Q

How To Look at the Current SQL*Plus System Settings in Oracle?

✍: FYIcenter.com

A

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
...

⇒Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2020-07-22, 668👍, 0💬

Change SQL*Plus System Settings in Oracle
How To Change SQL*Plus System Settings in Oracle? SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto-commit feature. SET FEEDBACK OFF - Stops displaying the "2... 2020-07-22, 717👍, 0💬

Run PL/SQL Statements in SQL*Plus in Oracle
How To Run PL/SQL Statements in SQL*Plus in Oracle? If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL> SET SERVEROUTPUT ON SQL> EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to FYIcenter!') Welcome to F... 2020-07-22, 693👍, 0💬

Show Current SQL*Plus System Settings in Oracle
How To Look at the Current SQL*Plus System Settings in Oracle? 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 ... 2020-07-22, 669👍, 0💬

SQL*Plus Environment Variables in Oracle
What Are SQL*Plus Environment Variables in Oracle? Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The home directory where your Oracle client application is ins... 2020-07-22, 647👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.