Re:Re: sqlplus setting

[Quoted] It does not work. The spool file will be like this

set sqlprompt test-prog1
>

but when you run it, it will be

>set sqlprompt test-prog1

test-prog1>
SP2-0042: unknown command ">" - rest of line ignored.
test-prog1

Any other suggestions?

Thanks in advance.

<u132781982_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.985882156.1743835449_at_[198.138.198.252]...
> Hi, I run the following script at glogin
>
> set head off
> set term off
> variable a varchar2(100)
> exec :a := dbms_Utility.port_string;
> spool c:\z.sql
> select 'set sqlprompt '''| |substr(global_name,1,6)| |'-'| |user| '> '''
> from global_name;
> spool off
> _at_c:\z
> set pages 66
> set head on
> set term on
>
>
> So that everytime I login Sqlplus, my sqlplus prompt will be looking like
 this
>
> Test-Prog1>
>
> But it is a little bit unconvinent, can somebody suggest a better way so
 that the sqlplus prompt will look like
>
> test-prog1
> >
>
>
> Put a return command before '>'?
>
> Thanks for your help
>
>
>
>
> --
> Sent by dbadba62 from hotmail in field com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new

Just include ||chr(10)|| before the '>'

Hth,

Sybrand Bakker, Oracle DBA  

-- 
Sent  by dbadba62 from hotmail subpart from com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new