Hi Everyone,
I'm working on a project an having difficulty getting the correct results. I'm using a sub query to get a value, but the values come back NULL and I need to display NULL as zero. I've tried nvl, coalesce, and nullif - nothing seems to work, value continues to return null in SQL developer. Does anyone have any suggestions ? Thank you in advance !
(SELECT nvl(total_capacity, 0) FROM logical where status = 'undiscovered') as Waste