SELECT * should be avoided because it releases control of the returned columns and could therefore lead to errors and potentially to
performance issues.
Noncompliant code example
SELECT *
FROM persons
INTO newyorkers
WHERE city = 'NEW YORK'.
Compliant solution
SELECT firstname, lastname
FROM persons
INTO newyorkers
WHERE city = 'NEW YORK'.
