Why is this an issue?
SELECT * should be avoided because it releases control of the returned columns and could therefore lead to errors and potentially to
Noncompliant code example
SELECT * INTO myvar FROM DUAL; -- Noncompliant
SELECT dummy INTO myvar FROM DUAL;
Wrapper queries using
ROWNUM are ignored.
FROM ( SELECT fname, lname, deptId
WHERE rownum <= 10