All Forums Database
mihirdhakan93 14 posts Joined 04/15
21 Apr 2016
Pass Table name in from statement by Other means

Hi All,
 
It may seem weird, but i came across this. i have a stored procedure written which takes isource_db as input, Eg: UAT_GCFR_VIEW.XYZ
Now Ahead in the Stored Procedure, i need to execute select statement like (eg.) : SELECT * FROM DEV_GCFR_VIEW.XYZ However, I want to replace the DEV with UAT(i.e whatever given by user in iSource_db variable.
 
Guys, can you please Help me out on this?

AtardecerR0j0 71 posts Joined 09/12
22 Apr 2016

You can do something like this:

'UAT'||substr(:isource_db,4)
 

Be More!!

You must sign in to leave a comment.