Print Thread
Table Description: Order by Type Issue
#64523 03/23/23 03:25 PM
Joined: Apr 2020
Posts: 92
Z
zakko Offline OP
Member
OP Offline
Member
Z
Joined: Apr 2020
Posts: 92
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)

Re: Table Description: Order by Type Issue
zakko #64525 03/24/23 09:51 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.021s Queries: 15 (0.006s) Memory: 2.4950 MB (Peak: 3.0378 MB) Data Comp: Off Server Time: 2024-04-19 09:11:46 UTC
Valid HTML 5 and Valid CSS