Re: Oracle Script For Menu

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Jun 2005 07:05:12 -0700
Message-ID: <1118412312.002678.249390@f14g2000cwb.googlegroups.com>

Arijit, Sybrand is correct and SQLPlus has no looping construct either.

One way to accomplish what you want is to use a shell script to display the options and accept the selection followed by a case statement where the appropriate sqlplus script is executed via batch:

sqlplus -s username/password @script

Another method is while SQLPlus has no loop it does support recursion. You can recursively call a routine however there is a limit. It was around 20.

HTH -- Mark D Powell -- Received on Fri Jun 10 2005 - 09:05:12 CDT