Oracle reads table structures and comments to generate database structure documents

Sometimes, after creating a database, you must submit the database structure document to the customer. Directly generate using the following SQL statement:

Select a. column_name field name, A. data_type data type, A. data_length length, A. data_precision
Integer, A. data_scale decimal point, A. nullable allows null values, A. data_default default value, B. Comments
Remarks from user_tab_columns A, user_col_comments B where a. column_name = B. column_name and A. table_name = B. table_name and A. table_name = 'test'

Replace test with your table name, mainly in uppercase.