Oracle queries the database table name and field information in the table

The query results of the oracle database table name and field information in the table are the table name, field name, field type, field length, and default value.

Select col. TABLE_NAME, col. COLUMN_NAME, col. DATA_TYPE, col. DATA_LENGTH, col. DATA_DEFAULT, com. comments from user_tab_columns col inner join user_col_comments comon col. TABLE_NAME = 'your table name' and col. TABLE_NAME = com. TABLE_NAME andcol. COLUMN_NAME = com. COLUMN_NAMEorder by col. COLUMN_ID

 

2. query the table name

Select TABLE_NAME from tabs where Table_Name = 'your table name'