Pular para o conteúdo principal

SELECT * should not be used

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;