replace values in Table name

[Anonymous]

Hi Everyone,

I am loading the data dynamically into oracle tables by giving TableName as:

"STG_"+SQLike.mid_index(((String)globalMap.get("tFileList_1_CURRENT_FILE")),".",1)

where STG is the Prefix.Actual Table name is STG_xxxxx4617.

Now,I do not want my table name to consider 4617.So i have to replace 4617 with nothing (or blank).

Let me know if this is possible in the same query?

Regards,

Mohit

[vapukov]

in the same query - not, but you can add filter by context and redirect data by destination