Disconnect From Oracle Database Tutorial Example

How To Disconnect From Oracle Database Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to disconnect from Oracle Database Server Tutorial Example

   set ORACLE_SID=xe
   C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe /nolog

   -- Oracle Client Location: C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe
   -- ORACLE_SID: xe
   -- username: TUTORIAL
   -- password: TUTORIAL

   -- modify your client location, oracle sid, username, password accordingly.
   -- i am using sqlplus as client. you can use anything as you like.

   -- just copy and paste the bellow code in ms-dos prompt to connect then disconnect to/from oracle database server
 
   conn TUTORIAL/TUTORIAL;
   -- to connect to database providing username/password
   SHOW USER;
   -- to view current session user
   EXIT;
   -- to disconnect from database
   -- OR you can use
   DISCONNECT;
      -- that's it!! we are connected then disconnected to/from oracle database using the mentioned credentials
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Disconnect From Oracle Database Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Create Table In Oracle Database Tutorial Example
  2. How To Drop Table In Oracle Database Tutorial Example
  3. How To Truncate Table In Oracle Database Tutorial Example
  4. How To Insert Row In Oracle Database Table Tutorial Example
  5. How To Insert Specific Columns In Oracle Database Tutorial Example
  6. MySQL IFNULL() Function String Example
  7. MySQL Stored Procedure Function: How to Drop a Stored Procedure Example
  8. 19 Examples to Learn MySQL
  9. 20 Steps to Learn CakePHP by Example
  10. UNIX Command Example: Display File Last Modification Information

No comments:

Post a Comment

leave your comments here..