However, once it connects, it then returns the Oracle Database release and version information. The first thing returned when connecting via SQLcl is the SQLcl release number. Last Successful login time: Mon 13:23:13 +10:00 When you use SQLcl to connect to an Oracle instance, the release and version are displayed. SQLcl is a command line interface for working with Oracle Database.
This opens a new tab with the version information: The SQLcl Tool Select the appropriate connection and click OK. To do this, under the Reports pane, go to Data Dictionary Reports > About Your Database > Version Banner.Ĭlicking on Version Banner opens a prompt where you need to select the connection: If you’re using the SQL Developer GUI, and you don’t want to run the above views (or can’t remember their names), you can navigate to the applicable data dictionary report in the Reports pane. If you have the appropriate permissions, you can use the V$INSTANCE view to return just the version.ġ9.0.0.0.0 19.3.0.0.0 The PRODUCT_COMPONENT_VERSION ViewĪnother option is the PRODUCT_COMPONENT_VERSION data dictionary view.ġ9.0.0.0.0 19.3.0.0.0 The SQL Developer GUI Other columns include BANNER, BANNER_LEGACY, and CON_ID, but the BANNER_FULL column returns everything we need. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production The V$VERSION view returns the version and component level information. Here are seven ways to check which version of Oracle Database you’re running.
0 kommentar(er)
