![]() With the Partitioning, OLAP and Data Mining options Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production ![]() ![]() Select lower(user) || || global_name into gname from global_name I added this to glogin.sql on my Oracle 10gR2 client: Ok, I give my colorfull login.sql for unix terminals in 10g, largely inspired from this thread ! Please note that _USER is not equivalent to &_USER because &_USER is executed only during the "set sqlp" and _USER is executed for each prompt. However, the prompt buffer is limited to 50 characters, so if you have _PRIVILEGE" in your prompt, you have only 12 character left. SQL> set sqlp _PRIVILEGE> AS SYSDBA> conn > quit ![]()
0 Comments
Leave a Reply. |