SQL connect Tip



I am lazy to make Tns entry in TNSNAMES.ORA file
But, still you can connect sqlplus session using following tip
make the tns entry as shown below , First  open sqlplus connect window then follow below steps


Syntax:


(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xyzabc.com)(PORT=1521))(CONNECT_DATA=(SID=Devep11i)))


Username : apps
Password : apps
Host string : < paste above tns entry here>

click on ok , it will connect to specified dbserver with making entry in TNSNAMES.ORA