Using the Easy Connect Naming Method

http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/naming.htm#sthref783

CONNECT username/password@[//]host[:port][/service_name]

sqlplus system/pwd@host:1521/PROD
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License