NULL
value indicates that the value does not exist in the database. In Oxla, you can use the NULL
option in the COPY TO
state to specify a string that will replace NULL
values when copying data from the table to a CSV file.
NULL
option in the COPY TO
is as follows:
table_name
: The table containing the data to be exported.file_path
: A CSV file location where the data will be saved.NULL ‘replacement_string'
: The specified string that will replace NULL values in the exported CSV file. The default value is ' '
.NULL
value.COPY TO
with an empty string:NULL
values in the table are replaced with the empty string in the CSV file.