Connect Oracle Database Server Tutorial Example

How To Connect Oracle Database Server Tutorial Example

Run MS-DOS command prompt then copy & paste the below code to Connect to Oracle Database Server as HR Tutorial Example

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

-- modify your client location, oracle sid, username, password accordingly.
-- i am using sqlplus as client. you can use anything as you like.
 
   set ORACLE_SID=xe
   C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe HR/HR@xe
      -- that's it!! we are connected to oracle database as hr using the above mentioned credentials
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Connect Oracle Database Server Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Show User Tables In Oracle Database Tutorial Example
  2. How To Create USER In Oracle Database Tutorial Example
  3. How To Drop USER In Oracle Database Tutorial Example
  4. How To GRANT a USER In Oracle Database Tutorial Example
  5. How To REVOKE ROLE from a USER In Oracle Database Tutorial Example
  6. MySQL NULLIF() Function String Value Example
  7. MSSQL PRINT Like Function in MySQL Example
  8. 20 Steps to Learn CakePHP by Example
  9. UNIX Command Example: GMT Date Time File Last Modification Information
  10. 19 Examples to Learn MySQL

No comments:

Post a Comment

leave your comments here..