Define Session Queries for different Oracle Versions

cassiusdrow

Member²
I support multiple systems that run on different versions of Oracle. Since the Oracle data dictionary and performance views change from version to version, I sometimes have to make several tabs for one query, each one customized for a different version of Oracle.

Is there a way to use different queries in the Session window (and possibly any other windows where the query is user-configurable) based on the Oracle version? If not, can that featured be added? I'm envisioning something as simple as a comment to separate the different query versions in the query text box:

/* ORACLE_8.1.7 */

/* ORACLE_9.1 */

/* ORACLE_10 */

 
Last edited:
Back
Top