I use this in combination with the login.sql. If you set the SQLPROMPT environment variabele (either manually or in the login.sql) the standard prompt is replaced by the name of the instance: SQL> set sqlprompt "_CONNECT_IDENTIFIER>" mydb> This is just a simple trick which is not well-known but makes life easier when using the good ol’ SQL*Plus commandprompt (and many people still do!).
0 Comments
Leave a Reply. |