IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
  • No replies
1731 Posts

Pinned topic Difference between 'set' and 'select into'

‏2013-03-05T17:19:13Z |
When developing in SQL PL, what is the difference between 'set' and 'select into'?

set var = (select count(1) from emp);

select count(1) into var from emp;

Are they completely equivalent?