Hi question to anyone experienced in using SQL exp...
# general
b
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
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)
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
Thanks @KevinJ of Kansas! I will explore those functions
b
I used TRUNC() for dates as well as lots of date addition.