What’s New in dbForge Studio for Oracle, v.3.7

SQL Editing and Execution

  • Suggestion and formatting of MERGE statements
  • Command-line interface for SQL formatting
  • Query execution pane
  • Option to change a snippets folder location
  • Phrase completion
  • Option to set files encoding within the /execute and /schemaimport command-line operation
  • Updated Find&Replace feature in documents and files

Data Comparison and Sync

  • Ignore difference in end of line option
  • Show white spaces option

Data Export and Import

  • Export to the Excel 2007 (XLSX) format
  • Retaining records filtering when the Export Selected Rows Only option is selected
  • Export of BLOB fields as TEXT to Excel, TXT, HTML, PDF, RTF, and CSV formats
  • Export to Excel, RTF, PDF with/without a header
  • Force quotes option when exporting data to a CSV file
  • Option to select encoding when exporting to DBF
  • Import of dynamic values from Excel and Excel 2007
  • Detecting column types when importing data from the CSV format

Data Report

  • Support of report parameters in the command-line interface

Database Explorer

  • Sending objects to a database diagram
  • Generate Script As shortcut menu item for check constraints
  • Renaming columns, indexes, default and check constraints
  • Updated unique key and primary key editors

Data Editor

  • Easy way to hide data results
  • Data Viewer and LOB Editor are combined into a single control
  • Redirect Data to Output is transformed into additional data editor

Other Features and Improvements

  • Support of multiple monitors
  • Create Schema Snapshot and Data Report wizard windows are modeless