rspec/rules/S2562/plsql/rule.adoc

== Why is this an issue?

For better readability, column aliases should be used with the ``++AS++`` keyword. If it is missing, it could be misread as another column being selected.


=== Noncompliant code example

[source,sql]
----
DECLARE
  result DUAL.dummy%TYPE;
BEGIN
  SELECT
    dummy d -- Non-Compliant - could be misread as selecting both "dummy" and a column "d"
  INTO
    result
  FROM
    DUAL;
END;
/
----


=== Compliant solution

[source,sql]
----
DECLARE
  result DUAL.dummy%TYPE;
BEGIN
  SELECT
    dummy AS d -- Compliant
  INTO
    result
  FROM
    DUAL;
END;
/
----

ifdef::env-github,rspecator-view[]

'''
== Implementation Specification
(visible only on this page)

=== Message

Add the "AS" keyword to this alias of "xxx".


endif::env-github,rspecator-view[]