SQL*Plus

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, 2016July 2, 2023

There're 4 ways to run SQL in just one command line. Run One Statement If your query contains just only one statement, you can do… Read More »

How to Set Autocommit ON and OFF

by Ed Chen
November 1, 2012December 17, 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 »

« Previous
1
2

JavaScript is not enabled. Please enable it and reload the page.