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.

Advertisements