Re: Question about pl/sql blocks

From: Mike Dwyer <dwyermj_at_co>
Date: Tue, 10 Oct 2000 07:25:38 -0600
Message-ID: <QSEE5.51$ww1.38974@wdc-read-01.qwest.net>

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