Other Oracle database topics - Re: Oracle Script For Menu

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Oracle Script For Menu

Mark D Powell

2005-06-10, 9:23 am

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 --

Sponsored Links