title: Variables in PLSQL
body: <p>I want to get the value defined in my Procedure as mentioned below.</p>
  <pre><code>declare
       city varchar2(50) := 'XYZ';
       TYPE table_type is table of table_name%rowtype;
       var table_type;
  
  begin
       select * bulk collect into var from table_name;
  
       DBMS_OUTPUT.PUT_LINE(var(1).field); -- Output is City
  </code></pre>
  <p>I want the output of</p>
  <pre><code>       DBMS_OUTPUT.PUT_LINE(var(1).field); -- Output is XYZ
  </code></pre>
  <p>How can I achieve this?</p>