Re: SQL*Plus Question

From: Gerald Anleitner <ga_at_phil.uni-passau.de>
Date: Fri, 3 Sep 1999 09:19:30 +0200
Message-ID: <37cf75ec.0@news.rz.uni-passau.de>

Anderson <tande922_at_hotmail.com> schrieb in im Newsbeitrag: 37CEE3F7.F67571BD_at_hotmail.com...
> Here's my problem. I have a script written in SQL plus and I want it
to
> loop.
> So the user can keep entering in their query until they type EXIT
for
> example?

I don't know what you mean by "SQL*Plus". As far as I know, pure SQL does not provide any means for loops. If you want to do the thing in PL*SQL, there shouldn't be a problem, there are all kinds of loop constructs (just copied from the PL*SQL documentation):

LOOP
sequence_of_statements
END LOOP; WHILE condition LOOP

sequence_of_statements
END LOOP; FOR counter IN [REVERSE] lower_bound..higher_bound LOOP

sequence_of_statements
END LOOP; Bye,
Gerald Received on Fri Sep 03 1999 - 02:19:30 CDT