And how do you define better in this case?
Faster? I suppose ltrim and rtrim are faster than trim but that you will not notice the diference with 100000 records. Same for others methods
Easier to understand? It depends on what you are used too. Looking at the way you ruled out nvl2 you will not find anything "better".
Some other metrics????
it sounds like that, but my primary task was to fillter spaces getting into my case or if statment.
to accomplish that i have to trim it becasue triming makes it empty and empty is treated as null, so now i chould fillter them using "is null".
so i was searching for any specific function made for them , but if trim is making spaces empty and out come can be compaired with "is null" to yield true.
then will use it throught out all stored proces in database.