iSQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88826-01 |
|
Command Reference, 17 of 38
DISC[ONNECT]
Commits pending changes to the database and logs the current username out of Oracle, but does not exit SQL*Plus.
Use DISCONNECT within a command file to prevent user access to the database when you want to log the user out of Oracle but have the user remain in SQL*Plus. Use EXIT or QUIT to log out of Oracle and return control to your host computer's operating system.
Your command file might begin with a CONNECT command and end with a DISCONNECT, as shown below.
CONNECT HR/HR SELECT LAST_NAME, DEPARTMENT_NAME FROM EMP_DETAILS_VIEW; DISCONNECT SET INSTANCE FIN2 CONNECT HR2/HR2
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|