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. |