Question and Answer Database FAQ3798B.txt SQL Explorer reports Oracle 8 database as Oracle 7 database Category :Database(Oracle8) Platform :Win95/NT Product : BC++5.x C++Builder1.0 C++Builder3.x Delphi2.x Delphi3.x Delphi4.x 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 3/26/99
Last Modified: 01-SEP-99