dbForge Studio for Oracle v3.7 release notes

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