Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Accept parameter in sql script and use it to create table

I am passing a parameter to my sql script @$SQL_SCRIPT ${PARMETER} and now i want to create a table using the parameter in the sql script. How do i append the parameter to the name of the table. This the syntax I'm using

CREATE TABLE TMP_LST_ITRMD_&1

This is for Oracle engine.

There is error in creating table, its not taking the actual parameter value, the table is being created by the name of TMP_LST_ITRMD_&1 itself.

Comments