Re: PL/SQL: DEFAULT vs. assignment

[Quoted] "Ahmed Baraka" <baraka_ahmed_at_hotmail.com> wrote in message news:<bsuidn$i2614_at_news.emirates.net.ae>...
> Use DEFAULT for variables that have a typical value. Use the assignment
> operator for variables (such as counters and accumulators) that have no
> typical value.
>
> A couple of examples follow:
>
> hours_worked INTEGER DEFAULT 40;
>
> employee_count INTEGER := 0;

> Note: Taken from Oracle 8 documentation.

[Quoted] I *know* that part of the documentation. I just don't understand it.

For example, if I wrote

   foo_bar_baz INTEGER := 4711;

instead of

   foo_bar_baz INTEGER DEFAULT 4711;

would my program behave different in some point?

Ronald Received on Fri Jan 02 2004 - 11:00:05 CET