Change the prompt in SQL*PLUS
From: <agi_at_mail.taicom.com.tw>
Date: Fri, 11 Jun 1999 02:21:08 GMT
Message-ID: <7jprqd$3hc$1_at_nnrp1.deja.com>
Hi, theres ,
Date: Fri, 11 Jun 1999 02:21:08 GMT
Message-ID: <7jprqd$3hc$1_at_nnrp1.deja.com>
Hi, theres ,
I have two problems:
[Quoted] 1.How do I write a script to change the prompt in SQL*PLUS like
follows :
sessionid,ser#_at_dbname> instead of just SQL>
[Quoted] 2.How can I run a sql script (lets say xxx.sql) without the old ....new two lines
SQL> _at_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 Fri Jun 11 1999 - 04:21:08 CEST