From: member38226@dbforums.com   
      
   Hi,   
      
      
      
   If you want the global db name in the sql prompt   
      
      
      
   put this line in the glogin.sql (affects all users) or login.sql(for   
   the user):   
      
      
      
   SET SQLPROMPT '&_CONNECT_IDENTIFIER:SQL>'   
      
      
      
   If you want to pass any value as the dbname just put:   
      
      
      
   SET SQLPROMPT '&_DB NAME>'   
      
      
      
   When you login to sqlplus this will prompt for the db_name.   
      
      
      
   Hope this helps   
      
      
   --   
   Posted via http://dbforums.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)