Oracle updates since version 22.2

Database Connection

  • Added support for Oracle Cloud JSON
  • Added support MySQL in Oracle Cloud
  • Added Oracle NetSuite driver
  • Updated the drivers for supporting Oracle Cloud 
  • View definition read was fixed for Azure databases
  • The Connection Wizard bug for Oracle with OS Authentication was fixed
  • The Oracle Cloud database connection issue was fixed
  • ​​The Wallet connection issue was fixed

Bugfixes and Improvements

  • Added the ability to directly execute SQL scripts in native clients 
  • Generate DDLs for Scheduler Jobs
  • Improved stored procedures invocation syntax
  • Added additional properties in the table info
  • Added information about the latest statistics update
  • Added Schema full DDL
  • New table column properties were fixed
  • VARCHAR2 is now the default string data type
  • Trigger DDL was fixed (CREATE keyword)
  • Data type DDL generation was fixed
  • nvarchar/nchar column length detection was fixed
  • Added the password expiration warning
  • The bug with missing attributes of key ‘VIRTUAL_PK’ in the result set was fixed
  • The bug with columns distortion when exporting data was fixed 
  • DATE data type rendering was fixed (the time part was removed)
  • DATE data type rendering is now configurable 
  • Dashboards bug was fixed
  • The data Compare bug was fixed
  • Incorrect Oracle data type in the result set was fixed
  • The issue with cropped ‘q’ at the end of the string was fixed
  • Stopped displaying the ‘filler’ time value when querying the DATE data type
  • The issue with parsing IF EXISTS statements were fixed
  • The display of DATE with additional settings in the Result Set was fixed
  • TNS import was fixed
  • The issue with native clients hanging when running SQLPlus scripts was fixed
  • The issue with setting the wrong schema after connecting or changing the Data Editor was fixed
  • Exception with reading table with null BLOB was fixed

Try the latest version of DBeaver PRO and have confidence that you are taking advantage of your database’s full power.