Oracle SQL tips and tricks + Unix/Linux Work Log
See how much a single Oracle SQL statement can do... Plus some Unix/Linux Work Log
Tuesday, December 18, 2007
Direct Oracle Connection without Tnsnames.ora
sqlplus username/xxxxx@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=machine_name)(Port=1521))(CONNECT_DATA=(SID=service_name)))
or
sqlplus username/xxxxx@machine_name:port/sid
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment