title: How to use PL SQL Constants in Insert statement
body: <p>I am new to PL SQL Code and need help writing Insert query statement .
  eg: I want to insert Employee in Employees table where only employee name changes but the city is constant.</p>
  
  <pre><code>DECLARE
    emp_var_prefix varchar2(12) := 'QATEST';
    emp_var_temp varchar2(12) := '';
    city constant varchar(30) := 'dallas'
  
  begin
    DBMS_OUTPUT.ENABLE;
    for i in 1..2 loop
      emp_var_temp  := emp_var_prefix;
      emp_var_temp := emp_var_prefix ||i;
  
      INSERT INTO EMPLOYEE TABLE ('EMPLOYEE_NAME', 'CITY') values ('emp_var_temp', '&lt;what should I put here for constant dallas for city name&gt;');
  
      DBMS_OUTPUT.PUT_LINE(emp_var_temp);
    end loop;
  
  END;
  </code></pre>