Another One From the Archives: Easy Connection Identifier
My good friend Joel showed me how you can connect to a (remote) database using an easy connect identifier. Here's how it works:
sqlplus sergiodb/sergiodb@//127.0.0.1:1521/mvl
It looks to be a way of constructing a connect identifier that's new since database 10g Release 1. The syntax is as follows:
[//]host[:port][/service_name]
The documentation sums it up nicely: The easy connection identifier can be used wherever you can use a full connection identifier, or a net service name. The easy syntax is less complex, and no tnsnames.ora entry is required.
