i just want to know that, there is any way through which i can Compare a column value with Some String value.Something like this...
supposecolumn name is SHIPMENT_EXPEDITE_HAWB
then can i have like this 开发者_开发知识库in plsql
SHIPMENT_EXPEDITE_HAWB=='PD'
Thaanks in advance!!!
You just need one equals, not two.
IF shipment_expedite_hawb = 'PD' THEN
dbms_output.put_line('Same');
END IF;
Just use the comparison operator =
E.g.
SHIPMENT_EXPEDITE_HAWB = 'PD'
精彩评论