ASC or DESC should be specified for every column of an ORDER BY clause to improve readability.
Noncompliant code example
BEGIN
SELECT col1, col2, col3
BULK COLLECT INTO result
FROM my_table
ORDER BY
col1 ASC,
col2, -- Noncompliant - ASC or DESC should be specified
col3 DESC;
END;
/
Compliant solution
BEGIN
SELECT col1, col2, col3
BULK COLLECT INTO result
FROM my_table
ORDER BY
col1 ASC,
col2 ASC,
col3 DESC;
END;
/
