Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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