Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: plsql: reading from console...???
def yn=Y
accept yn default &&yn char prompt '.. Continue Y/N?' [&&yn] '
In the above example, if the user hits enter with no selection, the default (Y) is used.
HTH
"Stefan Schubert" <stefan.schubert_at_itec-koeln.de> wrote in message
news:3B0516DA.54632B4C_at_itec-koeln.de...
> Hi there,
>
> I need to read users input on a console from plsql.
> Something like:
>
> "This will do .... Continue Y/N?"
> "> _"
>
> My books doesn't show any example.
>
> I tried DBMS_OUTPUT.GET_LINE but this just swollowed
> the line I produced by ...PUT_LINE and didn't showed and prompt.
>
>
> Can you help me?
>
> Thanks
>
> Stefan
>
> --
> ___________________________________________________
>
> i\tec Gesellschaft für Informationsmanagement mbH
> Oberländer Ufer 190a - 50968 Köln
>
> Mitglied von KPMG International
>
> Stefan Schubert - Berater - Dipl.-Inform.
>
> Fon: +49 (0)221 93724-18
> Fax: +49 (0)221 93724-50
> Mail: Stefan.Schubert_at_itec-koeln.de
> Web: http://www.itec-koeln.de
> ___________________________________________________
>
>
Received on Fri May 18 2001 - 14:25:41 CDT