SQLPlus Connect To connect a database, we usually use sqlplus, a text-based connection tool provided by Oracle to facilitate clients to connect to a running… Read More »SQLPlus Connect and Disconnect
SQLPlus without Tnsnames We usually connect a database by sqlplus through tnsnames.ora, but sometimes we are not allowable to change or access tnsnames.ora, even worse,… Read More »SQLPlus Connect without Tnsnames
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 »SHOW PARAMETER, How and Why
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 Execute SQL Statements in One CMD Line
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 »How to Set Autocommit ON and OFF