New Rule: specify columns to ORDER BY explicitly about plsql-and-sql-coding-guidelines HOT 2 CLOSED

from SonarQube

Column names should be used in a SQL "ORDER BY" clause

Even though the ORDER BY clause supports using column numbers, doing so makes the code difficult to read and maintain. Therefore the use of column names is preferred.

Noncompliant Code Example

BEGIN
  SELECT col2, col3
  BULK COLLECT INTO result
  FROM my_table
  ORDER BY
    1 ASC;           -- Noncompliant - if col1 is added to the selected fields, this may break
END;
/

Compliant Solution

BEGIN
  SELECT col2, col3
  BULK COLLECT INTO result
  FROM my_table
  ORDER BY
    col2 ASC;
END;
/

from plsql-and-sql-coding-guidelines.

This is a duplicate to G-3180

from plsql-and-sql-coding-guidelines.