Title: RE: SQLPROMPT
If I may add a suggestion to what Mr. Bobak had to say:
I have a connect.sql script in the same directory as the login.sql script.
The connect.sql script has the following lines:
connect &1 &2 &3
@@login
The reason I have "&2" and "&
database >
> We set this in Glogin.sql as :
>
> column global_name new_value gname
> select user||'@'||host_name global_name from v$instance,global_name;
> set sqlprompt '&gname>'
>
> We are able to get this prompt when we login to sql for th
We want to set the sql promp as username@database >
We set this in Glogin.sql as :
column global_name new_value gname
select user||'@'||host_name global_name from v$instance,global_name;
set sqlprompt '&gname>'
We are able to get this prompt when we login to sql