
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.
51 lines
676 B
Plaintext
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[]
|