选择案例，如果＆lt; 0然后选择＆＃x27; 0＆＃x27;

发布于 2025-01-18 16:47:05 字数 403 浏览 0 评论 0原文

在这里寻找一些指导。我有一个执行余额计算的查询，该查询也被格式化以显示在我们发出的信件上。如果 Total_Billable - Annual_Sum <0，我希望显示 0。基本上，我想避免在清洁度方面显示负数。见下文：

select TO_CHAR(NVL(:TOTAL_BILLABLE2 - :ANNUAL_SUM2,0),'$999,990')<br>
       into :REMAINING_BALANCE <br>
FROM SPRIDEN <br>
 where SPRIDEN.SPRIDEN_ID = :Student_ID

我觉得我过度思考了在哪里放置 CASE 语句，但这是我第一次使用变量来计算另一个变量中的存储值。任何帮助将不胜感激！

原文

Looking for a bit of guidance here. I've got a query performing a balance calculation that is also being formatted for display on a letter we've got going out. I'm looking to display 0 if Total_Billable - Annual_Sum <0. Basically, I want to avoid showing negative numbers for cleanliness. See below:

select TO_CHAR(NVL(:TOTAL_BILLABLE2 - :ANNUAL_SUM2,0),'$999,990')<br>
       into :REMAINING_BALANCE <br>
FROM SPRIDEN <br>
 where SPRIDEN.SPRIDEN_ID = :Student_ID

I feel like I'm VASTLY overthinking where to place my CASE statement, but this is my first go round using variables to calculate a stored value in another variable. Any help would be appreciated!

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

混吃等死 2025-01-25 16:47:05

使用案例：

select TO_CHAR(CASE WHEN :TOTAL_BILLABLE2 - :ANNUAL_SUM2<0 
                    THEN 0 
                    ELSE :TOTAL_BILLABLE2 - :ANNUAL_SUM2 END,'$999,990')
       into :REMAINING_BALANCE 
FROM SPRIDEN 
 where SPRIDEN.SPRIDEN_ID = :Student_ID

Use a CASE WHEN:

select TO_CHAR(CASE WHEN :TOTAL_BILLABLE2 - :ANNUAL_SUM2<0 
                    THEN 0 
                    ELSE :TOTAL_BILLABLE2 - :ANNUAL_SUM2 END,'$999,990')
       into :REMAINING_BALANCE 
FROM SPRIDEN 
 where SPRIDEN.SPRIDEN_ID = :Student_ID

回复收藏 0 原文

~没有更多了~