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
Post a Comment