Help - Search - Members - Calendar
Full Version: program for menu
Oracle DBA Forums > Oracle > Oracle Forum
hi sir,
i want plsql code for output as follows

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

- Vanilla SQL*Plus:

- Shell script call from pl/sql


- PL/SQL in Java or VB

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

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

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:
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.