Re: PL/SQL: DEFAULT vs. assignment
From: Ahmed Baraka <baraka_ahmed_at_hotmail.com>
Date: Wed, 31 Dec 2003 17:19:24 +0400
Message-ID: <bsuidn$i2614_at_news.emirates.net.ae>
Date: Wed, 31 Dec 2003 17:19:24 +0400
Message-ID: <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.
"Ronald Fischer" <ronaldf_at_eml.cc> wrote in message
news:219750c.0312300547.1975b9fc_at_posting.google.com...
> Is there any semantic difference between initializing a variable with
> DEFAULT, and doing it with the assignment operator?
>
> Ronald
Received on Wed Dec 31 2003 - 14:19:24 CET