Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Question about pl/sql blocks
I'm sure you meant TO_CHAR( birthdate, 'Day').
But the prompt will probably be in a SQL*Plus script. I'm not sure how you would write interactive code in PL/SQL.
"Jeremy Beal" <jbeal_at_jbeal.org> wrote in message
news:39e23e88.31931695_at_News.ai.com...
> On Mon, 09 Oct 2000 13:41:08 GMT, ajinaz_at_yahoo.com wrote:
>
> >Is it possible to create a block that prompts a persons birthdate and
> >returns the actual birth day of the week?
>
> NEXT_DAY(birthdate, 'Monday') should get you pretty close to what you
> need...
>
>
Received on Tue Oct 10 2000 - 08:25:38 CDT