Re: Really Easy Newbie Question - Please Help!

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 Tue Mar 28 2000 - 18:35:42 CST