SQL*Plus

How to Resolve SP2-0547: size option out of range

by Ed Chen
May 27, 2022May 28, 2022

SP2-0547 Saw error SP2-0547 when we tried to set the buffer size of server output in SQL*Plus. SQL> set serveroutput on size 1000; SP2-0547: size… Read More »

SHOW PARAMETER, How and Why

by Ed Chen
April 13, 2019December 8, 2021

What is SHOW PARAMETER? SHOW PARAMETER is a SQL*Plus specific command that can show all parameters, types and their values in a simple way. If… Read More »

How to Resolve SP2-0735: unknown SET option beginning

by Ed Chen
April 10, 2019December 8, 2021

SP2-0735 SP2-0735 is a SQL*Plus error which is very much like SP2-0158, they alert users that SQL*Plus cannot recognize the issued command. For example: SQL>… Read More »

How to Resolve SP2-0158: unknown SHOW option

by Ed Chen
April 6, 2019October 26, 2021

SP2-0158 SP2-0158 means that the issued command is not supported by this release of SQL*Plus utility. For example, we use SQL*Plus 11.2.0.4 to connect to… Read More »

How to Resolve SP2-0382: The SHOW PDBS command is not available

by Ed Chen
April 3, 2019February 4, 2021

SP2-0382 SP2-0382 means that the connected user are not privileged as SYSDBA, so SQL*Plus SHOW PDBS command is not available to the user. SQL> conn… Read More »

How to Execute SQL Statements in One CMD Line

by Ed Chen
June 3, 2016August 22, 2018

If your query contains just only one statement, you can do this:C:Usersed>echo select name from v$database; | sqlplus scott/tiger@orclWhen the query is finished, the command… Read More »

How to Set Autocommit ON and OFF

by Ed Chen
November 1, 2012May 19, 2022

Implicit Commit In the default behavior, if session A wants to see session B's results, he must be waiting for session B to commit his… Read More »