Home > database >  Oracle query table field name and note the order wrong problem
Oracle query table field name and note the order wrong problem

Time:10-20

There is a table field has more than 70 by PSL is to check the order id name from etc..
But by the SQL statement to check the name of the field and the corresponding remark,
B. select * from user_tab_comments where b b.t able_name=# {tableName},

The order of the query sequence and with view to see completely inconsistent,
Using mysql does not appear this problem before
Could you tell me how to solve the.

CodePudding user response:

User_tab_comments is table annotation, field depends on user_tab_columns, column_id sequenced,
  • Related