Hi question to anyone experienced in using SQL expressions in Saved Searches, what functions do you regularly use to meet clients' requirements? I know there are alot of functions just curious which ones are the most heavily used so I know which to focus on testing/learning
k
KevinJ of Kansas
11/24/2019, 11:15 AM
Most common I use are case statements, decode, nvl, to_char, to_date, nullif, I occasionally use listagg, ratio to report ( I Google that one every time I use it and it normally takes me an hour or two)
KevinJ of Kansas
11/24/2019, 11:17 AM
Decode is effectively a case statement that does the same comparison over and over. I still use case statements for more complex multifield comparisons , but I use decode far more often now for things I used to do case statements for
b
blue
11/24/2019, 11:59 AM
Thanks @KevinJ of Kansas! I will explore those functions
b
Bethany W.
11/25/2019, 1:58 AM
I used TRUNC() for dates as well as lots of date addition.