I am using Oracle Apex 22.1.6 for creating a data load definition in order to create a data loading page.
I have one column in the source file and that is the primary key column and it can be null sometimes in the source file. Since it is a primary key column, it should always have some value while loading into the table.
Either I can use the NVL function anywhere in the data load definition or I can use some transformation rule type to achieve this. Please suggest me the best way to do that.
Please let me know how I can transform this column to have some default value whenever it is null.
Thanks & Regards,
Annamalai V.