<div>
with the above statement i get a error:<br />
Error: Error in loading:table1-933ORA-0093<wbr />3: SQL command not properly ended
</div>


with the above statement i get a error:
Error: Error in loading:table1-933ORA-00933: SQL command not properly ended

<div>
thank you sdstuber, it worked!<br />
i have to add another cursor and pass mutiple 'lv_likevalue', let me test that too...
</div>


thank you sdstuber, it worked!
i have to add another cursor and pass mutiple 'lv_likevalue', let me test that too...

<div>
thank you sdstuber, works correctly!!
</div>


<div>
<div class="content wysiwyg-content">
hi, i have to use variables in select statement including a constant value, table name, and where clause, like so..<br />
execute immediate 'INSERT INTO table1 USING SELECT '<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||lv_source<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||', '<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||'col1, col2, col3 FROM '<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||lv_tablename<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||'WHERE TEMPLATE_NAME LIKE '<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||CHR (39)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||lv_likevalue<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||CHR (39);
</div>
</div>


hi, i have to use variables in select statement including a constant value, table name, and where clause, like so..
execute immediate 'INSERT INTO table1 USING SELECT '
                                ||lv_source
                                ||', '
                                ||'col1, col2, col3 FROM '
                                ||lv_tablename
                                ||'WHERE TEMPLATE_NAME LIKE '
                                ||CHR (39)
                                ||lv_likevalue
                                ||CHR (39);

How can i use variables in select statement?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.