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
- How To Show User Tables In Oracle Database Tutorial Example
- How To Create USER In Oracle Database Tutorial Example
- How To Drop USER In Oracle Database Tutorial Example
- How To GRANT a USER In Oracle Database Tutorial Example
- How To REVOKE ROLE from a USER In Oracle Database Tutorial Example
- MySQL NULLIF() Function String Value Example
- MSSQL PRINT Like Function in MySQL Example
- 20 Steps to Learn CakePHP by Example
- UNIX Command Example: GMT Date Time File Last Modification Information
- 19 Examples to Learn MySQL
No comments:
Post a Comment
leave your comments here..