replace values in Table name

Anonymous — Tue, 20 Nov 2018 14:01:09 GMT

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

Re: replace values in Table name

vapukov — Tue, 20 Nov 2018 22:08:26 GMT

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