Re: constant in pl/sql

From: Michel Cadot <micadot_at_altern.org>
Date: Wed, 28 Jul 1999 12:11:35 +0200
Message-ID: <7nml1i$52j$1@oceanite.cybercable.fr>

Anurag Minocha a écrit dans le message
<379E88B0.85E2B645_at_synergy-infotech.com>...
>Hi,
>can i assign sysdate to a variable and then use the variable at
>different places in the procedure the value of date being same and not
>changing since sysdate changes.
>
>
>anurag
>
>
>reply at
>anurag_at_synergy-infotech.com
>

Yes, you can.

Declare

my_date date := sysdate;
begin
/* use here my_date instead of sysdate */ end;
/ Received on Wed Jul 28 1999 - 05:11:35 CDT