COALESCE in create table?

General
Enthusiast

COALESCE in create table?

Hi,

Can someone please table whether we can provide coalesce for a column while creating table.

I have seen cases where you select using coalesce but could not find anywhere within create table

Thanks,

Sunitha

1 REPLY
Enthusiast

Re: COALESCE in create table?

Hi Sunitha,

you can use the default option which make sure that default value would be loaded if no value is provided for that column.