Re: sqlplus : how to select a comment from dual and delete on same line

From: Bricklen <bricklen_at_zyahoo.zcomz>
Date: Tue, 02 Nov 2004 01:26:55 GMT
Message-ID: <znBhd.77508$9b.69656_at_edtnps84>


GIMME wrote:
> Is it possible to combine the following two statements into one statement
> in SQL*PLUS?
>
>
> select 'dropping icogroup_links' from dual;
> drop table ICOGROUP_LINKS;
If you are using sqlplus for that, why don't you just issue a PROMPT?

PROMPT dropping icogroup_links
drop table icogroup_links;

if that won't work, what exactly are you trying to accomplish? More detail may reveal a different way to achieve your goals. Received on Tue Nov 02 2004 - 02:26:55 CET

Original text of this message