Really Easy Newbie Question - Please Help!

No it won't behave the same way because 1) the First colon indicates that it is an assignment operator. If it is just an = sign, then it is an equality operator.

2) The second colon indicates that the variable is a bind variable which means it is not a static variable but a dynamic one.

-----Original Message-----
From: Andrew [mailto:aka006_at_btinternet.com] Posted At: Tuesday, March 28, 2000 4:58 PM Posted To: misc
Conversation: Really Easy Newbie Question - Please Help! Subject: Really Easy Newbie Question - Please Help!

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.

Many thanks in advance

Andrew Received on Thu Mar 30 2000 - 14:52:29 CST