tag:blogger.com,1999:blog-8884584404576003487.post8066142590208262128..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: PL/SQL: Coding Practicesoraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-8884584404576003487.post-3303116232790231562009-08-20T09:39:46.061-04:002009-08-20T09:39:46.061-04:00Funny you mention that because in the real code th...Funny you mention that because in the real code that's exactly what I did. There were 3 or 4 ELSIF all on P_ID (in the example posted) so it lent itself nicely to the CASE statement. <br /><br />I like it better most times as I find it easier to read.oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-46483760861614281702009-08-20T05:31:59.730-04:002009-08-20T05:31:59.730-04:00You could also use case expressions. They support ...You could also use case expressions. They support a functional programming style, which often makes the data flow clearer than using side effects (variable assignments in a big if).Chrishttps://www.blogger.com/profile/00349422981782291908noreply@blogger.com