SELECT nullable FROM all_tab_cols WHERE owner = <<owner of table>> AND table_name = <<name of table>> AND column_name = <<name of column>>
will work if the column is marked NOT NULL, and not, say, with a CHECK
constraint, which checks that it is not NULL.
source share