rspec/rules/S1499/plsql/rule.adoc
Fred Tingaud 16f6c0aecf
Inline adoc when include has no additional value (#1940)
Inline adoc files when they are included exactly once.

Also fix language tags because this inlining gives us better information
on what language the code is written in.
2023-05-25 14:18:12 +02:00

51 lines
676 B
Plaintext

== Why is this an issue?
include::../description.adoc[]
=== Noncompliant code example
[source,sql]
----
DECLARE
myvar CHAR;
BEGIN
SELECT * INTO myvar FROM DUAL; -- Noncompliant
END;
/
----
=== Compliant solution
[source,sql]
----
DECLARE
myvar CHAR;
BEGIN
SELECT dummy INTO myvar FROM DUAL;
END;
/
----
=== Exceptions
Wrapper queries using ``++ROWNUM++`` are ignored.
[source,sql]
----
SELECT *
FROM ( SELECT fname, lname, deptId
FROM employee
ORDERBY salary
)
WHERE rownum <= 10
----
ifdef::env-github,rspecator-view[]
'''
== Implementation Specification
(visible only on this page)
include::../message.adoc[]
endif::env-github,rspecator-view[]