如何检查表中的列是否在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约束.
