
org.sonar.l10n.plsqlopen.rules.plsql.SelectAllColumns.html Maven / Gradle / Ivy
The newest version!
SELECT * returns all the available columns. You should explicitly list the necessary columns.
When considering using *, you should consider the possibility that more fields will be added to the table later.
Noncompliant Code Example
begin
select *
into var
from emp;
select emp.*
into var
from emp;
end;
© 2015 - 2025 Weber Informatics LLC | Privacy Policy