Partitioned table by range with interval

[Alexander1]

Hi!
The script of the partitioned table by range with interval is being built incorrectly. The interval parameter is not taken into account.

 

[Marco Kalter]

This is indeed on the list of enhancement requests.

 

[a_kassabian]

This has been an issue for at least 3 releases and is still not fixed. it's a significant issue because viewing a table and then switching to the SQL generates the cleanest DDL (better than DBMS_METADATA). However, the partitioning clause has to be written by hand. This also affects comparisons between schemas/databases because you get tons of false positives when the number of partitions is different, even when the DDL is the same.

Frankly, I would prefer this fix over any superficial updates to the icons, or the addition of a dark theme.