Favorite 10g feature
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Favorite 10g feature

  1. #1
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Favorite 10g feature

    My favorite 10g feature so far: login.sql gets re-run when you issue the connect command in sqlplus:
    Code:
    system@lx10g> connect jeffh/jeffh@lx10g.us
    Connected.
    $Id: login.sql,v 1.1 2003/10/29 15:15:27 jeffh Exp $
    jeffh@lx10g>
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: Favorite 10g feature

    Originally posted by marist89
    My favorite 10g feature so far: login.sql gets re-run when you issue the connect command in sqlplus:
    Code:
    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
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    i use this "loginid@whichdb>" feature at 8i.
    The man called Zorro

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    i quite like appending to a spool file

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

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width