Another One From the Archives: Easy Connection Identifier
By Sergio on Mar 10, 2009
My good friend Joel showed me how you can connect to a (remote) database using an easy connect identifier. Here's how it works:
It looks to be a way of constructing a connect identifier that's new since database 10g Release 1. The syntax is as follows:
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.