ارجو من الاخوة الاعزاء توضيح الفرق بين Decode و Case ، لاني أرى ان كلاً منهما يخرج نفس الناتج ، فأرغب بمعرفة الفرق بينهما .


وشكراً

أشكركم على هذه الفروق الرائعة

اخى العزيز يرجى ملاحظة التالى
In Case Of Decode
We Have A Return Value Only But,
In Case Of Case Statmen
It Is Like If Else Statment Which Mean That I Can Edit Some Commands To Be Executed When The Condition Is Satisfied
I.E The Case Statment Diff. From Decode
I Hope That It Is Clear And You Get My Point

1- the Case clause is available in oracle9i or later
2- in the case clause you can use the comparison operator (greater than , less than )
In the Decode clause you use equal operator only but there is a workaround for this prob

المشاركة دية ان شاء الله حتلاقى اجابتك فيها ان شاء الله

http://www.araboug.org/ib/index.php?showtopic=9676