Use case for regular-expression sorting solution

Advertisements

SQL> SELECT optimizer_feature_enable, bugno,
  2         description
  3    FROM v$system_fix_control
  4   ORDER BY
  5   RegExp_Replace (
  6   RegExp_Replace
  7   (optimizer_feature_enable || '.', '(d+.)', '00000001'),
  8                                     '0+(........).', '1'),
  9   bugno
 10  /

OPTIMIZER      BUGNO  DESCRIPTION
---------  ---------  -------------------------------------------------
             2194204  disable push predicate driven by func. index into
                      partition view
...
8.0.0        2663857  Use extended index caching discount
...
8.0.0        9785632  disallow slave group reuse in parallel query
8.1.6        1403283  CBO do not count 0 rows partitions
8.1.7        2324795  add(remove) cluster index for push view
8.1.7        2660592  do not trigger bitmap plans if no potential domain index
                      driver
9.2.0        2320291  push into table with RLS
9.2.0        2492766  use OR'ed predicates in index filter
...
9.2.0.8      3118776  Check for obj# for named view estimated card
9.2.0.8      4904838  allow index skip scan with no index keys
9.2.0.8      5005866  remove null first element from multicolumn inlist if
                      possible
...
10.1.0       3056297  No selectivity for source transitive equality join
                      predicates
10.1.0       3151991  use cost cutoff for first_rows
10.1.0       4550003  do not consider no sel predicates in join selectivity
                      sanity
10.1.0.3     3120429  account for join key sparsity in computing NL index
                      access cost
10.1.0.5     4308414  outer query must have more than one table unless lateral
                      view
10.1.0.5     4569940  Use index heuristic for join pred being pushed
10.2.0.1     3335182  use fkr_1 for (NOT) EXISTS subquery
...
11.1.0.6     4168080  Eliminate unneeded bitmap conversion
...
11.1.0.7     8557992  Enhance functional index checks when considering
                      OR-expansion
11.2.0.1      399198  ORDER BY sort elimination with OR expansion
..
11.2.0.2     9912503  Remove having clause subquery at all levels

551 rows selected.

As you can see, sorting by software version (or IP address!) is now pretty easy. And that was just one more new thing I've learned about Oracle Database.