title: SQL column name same as PL/SQL variable name - How can this be done in a select statement?
body: <p>Suppose I have a table:</p>
  
  <pre><code>create table foo (
    col_1     number;
    col_2     number;
  );
  </code></pre>
  
  <p>Then I have the following code</p>
  
  <pre><code>declare
     col_1    number;
     col_2    number;
  begin
     col_1 := 1;
     select col_2 into col_2 from foo where col_1 = col_1;
  end;
  </code></pre>
  
  <p>Of course this will not work as expected. How can one make it work without the need to change the variable names?</p>