SQL>
SQL> column nullable format a10 heading 'NULL|ALLOWED?'
SQL>
SQL> SELECT table_name, column_name,
2 DECODE(nullable, 'N', 'NO', 'YES') nullable
3 FROM all_tab_columns
4 WHERE table_name = UPPER('&table_name');
Enter value for table_name:
old 4: WHERE table_name = UPPER('&table_name')
new 4: WHERE table_name = UPPER('')
no rows selected