Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Really Easy Newbie Question - Please Help!
Cheers Bob,
All is clear now - what a relief.
Andrew
bob sullivan <bsullivn_at_home.com> wrote in message
news:38E14FAE.C9906D03_at_home.com...
> Andrew wrote:
> > Hi I'm new to Oracle & was wondering if anybody could tell me what the 2
> > colons in the following statement do. Would the statement behave the
same
> > without either colon?
> >
> > order_exceeds_balance := :customer.order_total > max_allowable_order;
> >
> > Sorry for being so dim, but I can't seem to find it in the documenation
> > anywhere.
>
> The first colon (preceding the equal sign) is part of the
> assignment operator, :=. The second colon designates
> :customer.order_total as a parameter. If you ran this statement,
> you'd be prompted to enter a value for :customer.order_total
> before the statement would run.
>
> cheers,
> ~bob
Received on Wed Mar 29 2000 - 11:36:38 CST