"IF" equivilent in SQL select?????

From: Vickie Jones <vjones1_at_nci2000.net>
Date: Thu, 6 May 1999 09:06:13 -0400
Message-ID: <ZhDX2E8l#GA.114_at_news.nci2000.net>

[Quoted] [Quoted] Is there a function(?) that would be the equivilent to an "IF" statment that [Quoted] can be used in a select statment? Below is a sample of what I am trying to [Quoted] do and the results:

analyze index ccdbp.ALARMS_CODES_KEY validate structure; col key_name format A50
[Quoted] select 'ALARMS_CODES_KEY' as key_name,del_lf_rows/lf_rows "Ratio" from index_stats;

ERROR:
ORA-01476: divisor is equal to zero

What I need is an "if" statement that says if lf_rows is 0 (zero) set 'del_lf_rows/lf_rows' to 0 (zero). I want to eliminate this error when I analyze my indexes.

Thanks in advance!
Vickie Jones
Republic Engineered Steels, Inc.
Canton, OH Received on Thu May 06 1999 - 15:06:13 CEST