hi sir,
i want plsql code for output as follows

menu
enter 1 for veg
enter 2 for non-veg

enter value:

after entering the number it have to show different items like
item1 cost $10
item2 cost $12
.
.
.


i tried this with case with substitution variables. it is asking variable first with out showing the menu. i want menu first then it should ask for entry. what can i do for this..

please help me..

thanks in advance
chitty

Hi Chitty,

>> program for menu, using plsql

This is the BC Oracle DBA forum, we are database administrators, not programmers here!

But I'll try to help you . . . .


*************************************************
>> i want plsql code

If you want to execute the PL/SQL in SQL*Plus this us very easy:

http://www.dba-oracle.com/t_interactive_pl..._user_input.htm

- Vanilla SQL*Plus:

- Shell script call from pl/sql

- PL/SQL in APEX

- PL/SQL in Java or VB

If you want to larn the whole area get the "Easy Oracle Pack":

http://www.rampant-books.com/menu_six_packs_bundles.htm#easy

And Laurents advanced SQL bok has some of the techniques:"

http://www.rampant-books.com/book_2008_2_a...programming.htm

If you don't want to write and test the code yourself, the Oracle code download has dozens of ready-to-run examples of PL/SQL displaying menu's:

http://www.dba-oracle.com/oracle_scripts.htm