parameter to sql statement in OracleEnterprise stage

[srinivas Guduru]

Hi

I am using Oracle Enterprisestage for Reading the data from a DB tables

In the SQL statement I am using 'LIKE' . I need to pass the parmeter value to LIKE in the sql select statement .

WHERE BA.col3 = SA.col3
AND MP.col2 LIKE 'SampleTable'

I want to parameterise the SampleTable value

Can you please provide the syntax for sql statement(LIKE 'SampleTable'
) and if any special syntax is there at under Prameters Tab please provide me this also

Thanks
Srini

[chulett]

Have you not used job parameters yet? They are typically enclosed in hash / pound signs when referenced, so:

WHERE BA.col3 = SA.col3
AND MP.col2 LIKE '#SampleTable#'

Where "SampleTable" is the name of your parameter. That's the basics, let's start there and see if it helps.

[pandeesh]

probably, it should be like,

LIKE '%#SampleTable#%'

depends on your requirements it may vary