Question:
Why does SQL Explorer report the database type as Oracle 7.3.2 when I
connect to an Oracle 8 database?
Answer:
SQL Explorer queries the SM$VERSION table using the sql statement
"select 'Oracle ' || VERSION_TEXT from SM$VERSION"
to determine the version of the database and it returns 7.3.2.
To verify that you are connecting to an Oracle 8 database query GV$VERSION.
example: select BANNER from GV$VERSION