Re: Change the prompt in SQL*PLUS

From: shailaja <saila_at_irmac.com>
Date: Tue, 15 Jun 1999 15:33:47 -0500
Message-ID: <929478730.127.31@news.remarQ.com>

First :

---

  U can change the sql prompt with the command "SET SQLPROMPT". SECOND

---

If u dont want to see the old and new use the command "SET VERIFY OFF"

shailaja

"<agi_at_mail.taicom.com.tw> wrote in message news:7jprqd$3hc$1_at_nnrp1.deja.com...
> 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 Tue Jun 15 1999 - 15:33:47 CDT