sql - Inserting null values when using bulk insert -

sql - Inserting null values when using bulk insert -

i have 1 table:

create table cust ( cust_id not null, cust_name not null, address null );

i have insert these rows table:

create table 1cust_det ( cust_id not null, cust_name not null, address not null );

unfortunately cust.address column contains null values. want insert these rows cust 1cust_det using cursor. have do?

insert cust_det select cust_id, cust_name, coalesce(address, 'unknown') cust

sql oracle plsqldeveloper