select: null or empty values
I have a table with many collumns.
when I use a "select" to see theirs values, many of them have a null value.
So, I am using the command to fill this fields;
- example: select if(MyCollumn IS NULL ,"-",MyCollumn ) from table
is it possible change all "null" for "-" in all collumns without declare one by one on select command?
Regards
Aecs
Subject
Written By
Posted
select: null or empty values
September 29, 2021 12:12PM
September 29, 2021 02:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.