Mega Code Archive

 

Categories / Delphi / ADO Database

 

Sql explorer reports oracle 8 database as oracle 7 database

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