Skip to main content

Hello, I would like to find the name of the IFS instance in a table/view :


Is this possible?
Thank you! 

I think this works:

SELECT Sys_Context('UserEnv', 'Db_Name') AS Instance FROM Dual

 

Good luck,

Joe Kaufman

Hi,

That instance name in the image is coming from the name of the MWS instance; if you have both MWS and database instances from the same name you can get it from sys_context 

Reply


Terms & ConditionsCookie settings