What is TNSNAMES? Whenever we need to connect to the database, we usually provide a connection string like this: SQL> conn hr/hr@chicago-db-server:1521/ORCL Connected. Or we… Read More »Where is TNSNAMES.ORA Location
What is ORACLE_HOME ORACLE_HOME is the location of Oracle database home directory, which contains many important file relationship we may use them very often. To… Read More »Where is ORACLE_HOME Location
OPatch Windows Assuming that you have downloaded the latest OPatch from Oracle. Let's see current version of OPatch utility. C:\Users\Administrator>opatch version OPatch Version: 12.2.0.1.15 OPatch… Read More »How to Replace OPatch on Windows
Differences between Oracle Client and Client Home You may have known the differences between Oracle client and Oracle instant client, but you may not know… Read More »Oracle Client vs Client Home
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