Setup sqlplus

This articel will show you how to setup to use sqlplus on a windows platform.

1. install an oracle client
2. retrieve and update tnsname
3. create a sqlplus working folder – like: c:\apps\sql
4. copy the needed (all) scripts from sql4oracle.com to the sqlplus working folder
5. update the login.sql
6. create a shortcut for each environment – and place them in the quick launch toolbar

Update TNSNAMES:

If tnsnames is using long complicated names – create short names for the environments: prod, preprod, dev, train, master, tech, R12… 

The sqlplus shortcuts:

name: <connection name>

destination: C:\oracle\oracle9i\bin\sqlplusw.exe <username>/<password>@<connection name>

start in: <the sqlplus working folder>