CODEWITHSUNDEEP
oracle-databaseoracle-apex
jrara
jrara

Reputation: 16981

How to change the way Oracle XE Application Express displays the NULL value?

I'm using Oracle 10g XE edition via Application Express and NULLs are displayed using - character. I found from the parameter listing that: 

+-------+-------+------------+--------------------------------------------+
| Name  | Value | Is Default |                Description                 |
+-------+-------+------------+--------------------------------------------+
| event | -     | TRUE       | debug event control - default null string  |
+-------+-------+------------+--------------------------------------------+

Is there a way to change this value so that NULLs are displayed NULL instead of -?

Upvotes: 0

Views: 2113

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60262

This is the default behaviour of reports created in Oracle Application Express (Apex).

You can change it to NULL or blank it out entirely by editing the Report Attributes - Show Null Values As.

Upvotes: 5

Related Questions