Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get file node name from SQL query

igweApr 12 2010 — edited Apr 14 2010

Hello everyone,
I have a concurrent request that requires the file node name as input. For example, when I login to oracle on our test instance , I use http://moon1.oando-plc.com:8000. For this concurrent program, the file node name is shown as moon1.oando-plc.com.
I need to use this argument in a PL/SQL procedure I am writing and I don't want to use any hardcoding.
Is there any way to get this data from an SQL statement. I am able to get things like instance name and host name from an SQL query but I am not sure about file node name.
Any help will be appreciated.
Thanks a lot.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 12 2010

Added on Apr 12 2010

#general-database-discussions

7 comments

2,925 views