如何检查表中的列是否在oracle db中具有非空约束？可以用数据字典检查吗？
SELECT nullable FROM all_tab_cols WHERE owner = <<owner of table>> AND table_name = <<name of table>> AND column_name = <<name of column>>
将假设列标记为NOT NULL而不是比如具有检查它是非NULL的CHECK约束.
SELECT nullable FROM all_tab_cols WHERE owner = <<owner of table>> AND table_name = <<name of table>> AND column_name = <<name of column>>
将假设列标记为NOT NULL而不是比如具有检查它是非NULL的CHECK约束.
