title: PL/SQL UPDATE/INSERT with table's variable
body: <p>It is possible to build a statement using variables for the table name without creating a VARCHAR and using EXECUTE IMMEDIATE?</p>
  
  <p>ex:</p>
  
  <pre><code>@table_name := test_table
  
  UPDATE @table_name
  SET col1 = val1
  WHERE condition...;
  </code></pre>
  
  <p>this is my actual workaround:</p>
  
  <pre><code>DECLARE
    sql_stmt VARCHAR2(1000);
    table_name VARCHAR2(30) := 'test_table';
  BEGIN
    sql_stmt := 'UPDATE ' || table_name || ' SET col1 = val1...';
    EXECUTE IMMEDIATE sql_stmt;
  END;
  /
  </code></pre>