-
Hi,
When I type sqlplus from the unix prompt and get into the sql prompt. I want certain things to be set initially. Like for Ex : set timing on, set head off,etc. Just like what a .profile does when you log into your account in a Unix box. Is there any way to do this in Oracle.
Thanks,
Umesh
-
Hi,
$ORACLE_HOME/sqlplus/admin/glogin.sql
is the file you can put your settings in.
Regards,
Ales
-
What if I am a normal user and not an admin?
-
Then login.sql in your local directory.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|