org.sonar.l10n.plsqlopen.rules.plsql.SelectAllColumns.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of zpa-checks Show documentation

Z PL/SQL Analyzer :: Checks

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;