Hello, I would like to find the name of the IFS instance in a table/view :
Is this possible?
Thank you!
Best answer by sutekh137
View original
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.