We can set up any environment variable by following these steps:1. Search for a file called glogin.sql on your hard drive (Where Oracle is installed).
2. Open this file with the text editor of your choice and add the commands you wish.
Some of the Commands could be:
set sqlprompt ‘INDIA%’
set echo on
set serveroutput on
Log into your Oracle account and SQL plus automatically execute the commands you indicated.
Aug 23, 2005 @ 21:13:00
Hi Archu,
Nice Blog!!!
Regarding the Sqlprompt setting at login– I have a slight variation.
This piece of code lists the user as logged in.
Just paste this code in the glogin.sql file at the end
—–SQL code ———-
set termout off
define new_prompt=’nolog’
column value new_value new_prompt
select username || ‘: ‘ || substr(substr(global_name,1,30),1, instr(substr(global_name,1,30),’.')-1) value
from user_users, global_name;
set sqlprompt “&new_prompt> ”
set termout off
—End of SQL code———–
Aug 24, 2005 @ 10:13:00
thanks shantanu
wil chk it out.. but not now since no oracle.. iam wokring in knoppix these days..