Posted in SQL*Plus by Andrew Tulley on the March 13, 2008

Time for a quick “did you know..?“

You can connect to an Oracle Database using SQLPLUS without the need for a tnsnames.ora file using the following syntax:

sqlplus sys/password@//server:1521/orcl as sysdba

	Andrew Tulley on New URL for this blog
	Jackie on New URL for this blog
	Renat on Tool to replace bind variables…
	Andrew Tulley on ApEx: Client-side date au…
	Jeff on ApEx: Client-side date au…

Andy’s Blog: Application Express etc.

Explicit connection to a database without using tnsnames