I seem to remember reading about a way of being able to specify the entire connection string on the command line when using sqlplus. Ie you can give the client the details of a database that isn't in the tnsnames.ora file, or force it to use a different port.

Does anyone know the syntax for this?