Table Description: Order by Type Issue - 03/23/23 03:25 PM
The ordering in the table description window is not precise or at least not intuitive:
Precondition: Table with e.g. varchar2 columns of length below and above 10 characters.
1. Open description window of a table: SQL Window > right-click table name > Table [table name] > Describe
2. Order by "Type".
Observed sorting:
varchar2(3)
varchar2(36)
varchar2(4)
Expected sorting:
varchar2(3)
varchar2(4)
varchar2(36)
Precondition: Table with e.g. varchar2 columns of length below and above 10 characters.
1. Open description window of a table: SQL Window > right-click table name > Table [table name] > Describe
2. Order by "Type".
Observed sorting:
varchar2(3)
varchar2(36)
varchar2(4)
Expected sorting:
varchar2(3)
varchar2(4)
varchar2(36)