Values plus Values under Keys

Content Authoring
1

(imported topic written by SystemAdmin)

Playing around with some Oracle SqlNet relevance.

How would you do this one?

I might have a value retrieved like:

value “ORACE_HOME” of key “HKEY_LOCAL_MACHINE\Software\ORACLE” of registry

I might also have sub-keys that also have values, such as:

values “ORACE_HOME” of keys of key “HKEY_LOCAL_MACHINE\Software\ORACLE” of registry

How can I combine these so it effectively returns 1 set of values? I’m also thinking of how could I concatenate two sets of values into one big set of values if those values came from different keys around the registry.

Reason:

Oracle SqlNet 9i (and lower) stores where the current ORACLE_HOME in-use in the Oracle key. SqlNet 10g has sub-keys under the Oracle key that each has their own ORACLE_HOME. I want to come up with 1 set of values to return as a retrieved property.

After this one, I’m tempted to try to determine which SqlNet (if multiple are installed) are active by looking at the environment PATH to see which one comes first. First one found in the PATH is the winner. But I think I’d need all of the ORACLE_HOME values as 1 list to locate them in the PATH.

Paul

2

(imported comment written by SystemAdmin)

Hmm… Maybe I should have thought this through a little more and looked for a simplier answer. Sometimes I overthink this.

(value “ORACLE_HOME” of key “HKEY_LOCAL_MACHINE\Software\ORACLE” of registry as string); (values “ORACLE_HOME” of keys of key “HKEY_LOCAL_MACHINE\Software\ORACLE” of registry as string)