Re: Three SQL*Plus Questions

On Wed, 18 Feb 1998 21:39:47 -0600, Frank Hubeny <fhubeny_at_ntsource.com> wrote: Hi,
ist in the dbs subdir.

>This is a multi-part message in MIME format.
>--------------62B5CF52F7E27624DDCC9717
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>I don't believe the following are possible to do in either plus33w.
>Are they possible in plus80w?
>
>1) Can I dynamically change the prompt from "SQL>" to the username of
>the user to whom I am connected at the moment? That is, if I connect as
>user SYSTEM, then "SYSTEM>" would appear as the prompt without my having
>to do anything but make the connection.
>
>2) Can I make host commands execute in a sequential, rather than
>parallel, manner by changing some parameter setting? That is, the two
>commands "host sqlldr73 ..." and "host sqlldr73..." placed in the same
>file would execute one after the other rather than simultaneously.
>
>3) Is there some way to make conditionals work? That is, if I have
>the following script
>
> prompt Enter the password for user XXXX:
> connect XXXX
> start myfile.sql
>
>can I detect if the password was incorrectly entered in order to allow
>the user of the script to try again?
>
>--------------62B5CF52F7E27624DDCC9717
>Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Frank Hubeny
>Content-Disposition: attachment; filename="vcard.vcf"
>
>begin: vcard
>fn: Frank Hubeny
>n: Hubeny;Frank
>adr: 427 East Liberty Drive;;;Wheaton;IL;60187-5510;USA
>email;internet: fhubeny_at_ntsource.com
>x-mozilla-cpt: ;0
>x-mozilla-html: TRUE
>version: 2.1
>end: vcard
>
>
>--------------62B5CF52F7E27624DDCC9717--
>

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de