ON NULL?

May 6, 2014 — Leave a comment

and another little new feature of oracle 12c: ON NULL for table columns definitions

SQL> !cat a.sql
CREATE TABLE T1 ( a number
                , b varchar2(5) default on null 'aaaaa' not null );

insert into t1 ( a,b ) values ( 1,'aaaa');
insert into t1 ( a,b ) values ( 1,null);
select * from t1;

	 A B
---------- -----
	 1 aaaa
	 1 aaaaa

on null

Advertisements

No Comments

Be the first to start the conversation!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s