Favorite 10g feature

[marist89]

My favorite 10g feature so far: login.sql gets re-run when you issue the connect command in sqlplus:

system@lx10g> connect jeffh/jeffh@lx10g.us
Connected.
$Id: login.sql,v 1.1 2003/10/29 15:15:27 jeffh Exp $
jeffh@lx10g>

[stmontgo]

Originally posted by marist89
My favorite 10g feature so far: login.sql gets re-run when you issue the connect command in sqlplus:

system@lx10g> connect jeffh/jeffh@lx10g.us
Connected.
$Id: login.sql,v 1.1 2003/10/29 15:15:27 jeffh Exp $
jeffh@lx10g>

that is cool, i'm looking forward to messing with rolling uprades, it could mean in our environment zero downtime scheduled or otherwise, sweeeeeettttttt

[zainalj]

i use this "loginid@whichdb>" feature at 8i.

[davey23uk]

i quite like appending to a spool file

All the feature that should of been there since 8i :-)

[marist89]

Originally posted by zainalj
i use this "loginid@whichdb>" feature at 8i.

Oh really? I would love to know how when you are already connected to a database in 8.1.x and issue "connect u/p@another_db" it automatically runs your login.sql. Please, enlighten me.