Change the prompt in SQL*PLUS

Hi, theres ,

   I have two problems:
   1.How do I write a script to change the prompt in SQL*PLUS like      follows :

     sessionid,ser#@dbname> instead of just SQL>

    2.How can I run a sql script (lets say xxx.sql) without the     old ....new two lines

    SQL> @xxx cust
    old 2: where table_Name = UPPER('&1')     new 2: where table_Name = UPPER('cust')

    Just see the query result.

   Appreciate for any suggestions !!

Rgds,
Agi Chen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 10 1999 - 21:21:08 CDT