Alt SQL Developer for Oracle Change Log ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- release 1.65.212 (24-Apr-2017) + added: Some 12c keywords and functions support + added: Table Editor: support inmemory options table level + added: Table Editor: support inmemory options column level + added: Table Editor: support advanced index compression + added: Table Editor: support generated identity + added: Table Editor: support invisible columns + added: Table Editor: support invisible indexes + added: Table Editor: support validate constraint + added: Objects Window: special icons for inmemory tables (with red left column) + added: Materialized View Editor: support ON STATEMEN clause + added: support 128 bytes names + added: Windows List: Commit & Rollback hint indicator + added: Recognize type of clicked object is improved * fixed: command Change Window less file name Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.63.210 (19-Dec-2016) + added: Some 12c keywords + added: Mat view log editor: Commit SCN checkbox + added: View editor: recognize Editioning views + added: Window List: show object names for editing views and mat view logs * fixed: Command Window: Updade command can recognize wrong Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.62.208 (05-Dec-2016) + added: Export Tables Window: Fields Selection button added * fixed: Table Editor Window: wrong table size on Statistic tab if LOB Included checked * fixed: Import Table Data Window: big size CSV file can raise memory error * fixed: when Connect and Restore files locked, user can't connect and close the application * fixed: wrong attributes sorting when JSON beautifier applied * fixed: Export Tables Window: Fields Selection Dialog from CSV tab can show wrong checked list of fields Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.61.207 (07-Nov-2016) + added: Main menu Tools -> SQL Monitor. Now you can see all sql statements which you and IDE send to database. + added: New button JSON Formatter for main toolbar. + added: Table editor: Rename Index command supported. + added: Mat View Window: New button Show Indexes Size. * fixed: A lof of small fixes in each window and componets updates Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.55.201 (14-Jan-2016) + added: Main menu File -> Recently closed windows. Now you can reopen recently closed windows. + added: Table editor: User interface was extended for Interval partition table. + added: Table editor: Column Stat num rows added in Partitions grid and Subpartitions grid. Now you can see partitions and subpartitions record count from statistics. + added: Links for object window: Column Stat num rows added. Now you can see quntity of records from statistics. + added: Context menu item "Camel case" for selected text in text editor. Now you can format main_table -> Main_Table. + added: User editor: Role priveleges information was extended. Now you can see roles and privileges included in roles granted to user. + added: Changed file dialog window: Button Differences added for showing changes. + added: Dialog window for export SQL dml delete/update/merge from grid has field where you can choose unique set of fields for dml export. + added: Compiling DB objects Package/Function/Procedure/etc in separete session. Now compiling objects in a Program window does not hang the application. + added: Program window: Object inspector: click a Declare block to move cursor at start declare position. + added: Main menu, Value editor window, XML editor window have XML Format button. + added: Improve the Find column in grid dialog. Now you can search column which has text for search anywhere (before it could be searched by start of column name). + added: Improve of running macroses. + added: Improve of recognition constants and variables in Explain plan window. + added: Context menu item Drop for all DBMS_Scheduler objects. * fixed: Import table data window works with CSV data * fixed: Command window: set autotrace command Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.54.192 (27-Aug-2015) + added: Objects window: added folder: Materialized View Log + added: Materialized View Log editor + added: Toolbar: added button Add for logging (Now you can insert dbms_output.put_line() or your logging script just press the button or hotkeys) + added: Toolbar: added buttons for Record and Play Macros + added: Find Database Objects Window: added buttons for add more records of script in find result Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.47.179 (16-Mar-2015) + added: SQL Window: Consecutive DML/DDL operations group in one tab Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.46.175 (03-Mar-2015) + added: Program Window: Improve speed for code navigator + added: Preferences -> SQL Window: Several new options: - Show dictionary info in result grid - Show gutter (line numbers) - Trim fixed char * fixed: DBMS_Scheduler -> Job: Sort errors Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.45.174 (16-Feb-2015) + added: Grid with errors for View Editor + added: Preferences -> Files -> Format -> End - of - line format Encoding + added: Main menu -> Edit -> File Encoding File Format + added: Session Window: added LongOps tab + added: Session item for Window Panel Context Menu * fixed: Table Editor: wrong script for long column names * fixed: Scheduler Job Editor: sort logs by time Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.42.170 (11-Nov-2014) + added: ER-Diagram Window supports View and MView + added: Improve Code completion in hierarchical WITH ... SELECT + added: Main tool bar can have buttons Execute NonStop and Execute Current SQL for SQL Window + added: Window Export Grid Settings save window params + added: Commit every n row added in Window Export Grid Settings + added: CheckBox Set define off added in Window Export Grid Settings + added: Main menu -> DBA -> AWR Report + added: Main menu -> DBA -> Script: Who locked the compile + added: Main menu -> Session -> Session Info + added: Explain plan Window: Replace settings added * fixed: Table editor does not generate interval clause Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.41.169 (15-Oct-2014) + added: ER-Diagram Window + added: Event Monitor Window + added: Connection Editor Form + added: Explain Plan Window: Compare & Diff Plans + added: Explain Plan Window (Copy from Package): Replace constants to value + added: Export Grid Settings: Export to XLSX + added: Support q'{...}' expression in SQL Window + added: Support Oracle 12c WITH FUNCTION ... SELECT clause + added: SQL Window Grid Result: Support Collection & User Defined Datatypes + added: Table Editor: Support Virtual Columns, Temporary tables, addition attributes + added: Paste into Search and Replace Window truncate text by new line + added: Improve perfomane load data in DBMS_Sheduler Job Window + added: Object Window: Enable / Disable dbms_sheduler.jobs functions in context menu * fixed: Code completion package specification parse * fixed: Code completion inside WITH ... SELECT clause * fixed: Start Preferences form from toolbar showing tabs * fixed: Start program on Windows 8 / 2008 Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.28.128 (26-Aug-2013) + added: DBF Viewer Window + added: Table Editor: Dialog for deleting objects + added: Program Window: Double click in procedure name in Code Navigator changes current tab and moves to selected procedure + added: Program Window: Synchronization of the cursor position and selected procedure in the code navigator + added: Rename Object Window: Case Sensitive checkbox added + added: Database Link Editor: Test Link button added + added: Export Grid Settings: Columns Headers checkbox added + added: SQL Window: Export to DBF from grid with selected results + added: SQL Window: Double click in result grid opens Value Editor for text fields + added: SQL Window: button Clone record added + added: Connection Window: button Clone added in the context menu + added: Record Count menu item added in the conext menu for tables and views + added: Analyze Advanced menu item added in the conext menu for indexes and tables + added: Expired Password Dialog for user with expired password + added: If status bar has last script error, mouse click on status bar shows this error + added: Command Window: added support commands: r[un] and short '/' get cl[ear] sql cl[ear] buff[er] set auto[commit] [ON | OFF | IMM[EDIATE] | 0-2000000000] set array[size] (1-5000) set colsep [separator | off] set feed[back] (0-50000) set hea[ding] [ON | OFF] set null [String] set serveroutput [ON | OFF] [SIZE] set suf[fix] set und[erline] [ON | OFF | Char] set blo[ckterminator] [ON | OFF | Char] set spa[ce] (0-10) * fixed: doesn't put quotation marks for case sensitive fields when Copy selected column heading or Copy for IN clause is in execution * fixed: Export to xls doesn't work on windows x64 * fixed: there are no operations analyze и rebuild in the context menu for index * fixed: Command Analyze doesn't work from context menu for case sensitive table name * fixed: Export storage options for partitions when this options disabled in preferences * fixed: Export byte and char for nvarchar * fixed: Export case sensitive partition name * fixed: Object Window: Save vertical scroll position on Refresh command * fixed: Object Window: Doesn't Refresh when create Materialized View * fixed: Command Window: frequent blinking for a variety of quick commands Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.27.115 (25-Jul-2013) + added: Tools -> DBA -> Alter System + added: Tools -> Session -> Alter Session + added: Tools -> Compare -> Compare Files + added: Tools -> Preferences -> Export -> Byte / Char precision in columns names for string datatypes + added: Object Window: item Compare added in context menu for compare two selected objects + added: Object Window: item Export Data added in context menu for open Export Tables Window for selected table + added: Object Window: item Explain Plan added in context menu for views and materialized views + added: Object Window: item Create dbms_ErrLog Table in context menu for tables + added: Object Window: items Insert & Log Error and Update & Log Error in context menu for tables + added: SQL Window: item Explain Plan added in context menu for views and materialized views + added: SQL Window: grid was optimized for 1000 columns + added: SQL Window: Export in SQL as Update, Insert & Delete and Merge + added: Invalid Objects Window: Popup menu for grid with errors (Items: Copy; E-mail; Go to) + added: Invalid Objects Window: Double click for grid with errors open script on error line + added: Explain Plan Window: items Open & Query data were added in contex menu for tables, views & indexes in explain plan grid + added: Explain Plan Window: item SQL + Plan CSV Export To Clipboard added in context menu in the grid + added: Explain Plan Window: item Preferences added in context menu in the grid + added: Explain Plan Window: item Analyze added in context menu in the grid for tables and indexes + added: Explain Plan Window: item Rebuild added in context menu in the grid for indexes + added: Editor: added Java lexer + added: Editor: Names like "Name_Part1 name_par2" available for context menu options + added: Filter in Select Visible Columns Window + added: Files Window: buttons for sort added in settings window + added: Command Window: support command Set Transaction added in command window + added: Export Tables Window: Export performance improvement + added: User Editor: item Open Role added in the contex menu for Object Privileges grid + added: User Editor: Button Delete supported multiselect rows + added: Program Window: Global variables visible in Code Navigator's declare section + added: Error Message: Button Go To Error Line added for certain errors + added: Some pictures for menu items * fixed: A lot of fixes in Test Window for debug PL/SQL * fixed: A lot of fixes for case sensitive names objects * fixed: Files Window: option Include Subfolders don't work * fixed: Fast double clicks on Refresh button in Object Editor Window can raise exception * fixed: Open User Editor can raise exception on Oracle under 11 version * fixed: User Editor: Operation Delete system privileges can't generate sql script * fixed: function Paste From Host Language for value from delphi debug variable * fixed: Export into SQL generate script for case sensitive columns names without '"' * fixed: Message "OCI.dll is not found" showing if oracle client is not installed Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.26.97 (02-Jul-2013) + added: Session -> SQL Trace + added: Tools -> Wrap Utility + added: Tools -> Preferences -> SQL Window -> Query Data command adds an alias for object + added: Tools -> Preferences -> SQL Window -> Query Data command generates script with columns names + added: Tools -> Preferences -> SQL Window -> Hide ROWID column + added: Tools -> Preferences -> Editor -> Function Separator (for visual separating functions in the package by lines) + added: Tools -> Preferences -> Editor -> Multicolored Blocks Staples (for visual tracking begining and ending blocks IF, LOOP, etc in Program Window) + added: SQL Window: Select Dropdown Lists button added to show values for IDs for related tables + added: SQL Window: Copy for IN clause menu item added in grid contex menu for easy script generating for IN or PIVOT clause + added: SQL Window: Calculate time of fetching records if grid scrollbar uses + added: Select query menu item added in sql editor contex menu. This item available if your SELECT clause was selected in sql editor. + added: Statusbar information more useful for SQL editor windows + added: Bookmarks menu item added for SQL editor + added: Explain Plan Window: Executing is in its own thread now + added: Explain Plan Window: The list of hints explaining the Optimizer's actions was extended + added: Explain Plan Window: Preferences button added + added: Test Window: drag&drop variables and parameters from sql editor added for grids + added: Test Window: Format column added into watch list grid + added: Test Window: Ability to change value of variables Watch List right in a grid + added: Test Window: Tab Breakpoints + added: Test Window: double click in call stack grid for move caret to source position + added: Test Window: Tab Htp Output + added: Test Window: Test command have option Check for debug information in the test procedure + added: Object Window: Query Data menu item added for pipelined functions + added: Object Window: DBMS_Scheduler + added: Object Window: Partition tables and Index Organization Patition tables have own icons + added: Object Window: Hotkey Del call Drop object operation, Hotkey Del+shift call Drop object with purge operation + added: Find Database Objects Window: Constraints check box + added: Find Database Objects Window: Available Open contex menu item for indexes, columns, columns comments, constraints, table comment + added: some pictures for menu items + added: Change password: Show Chars check box added + Startup performance improvement + Tools -> Preferences -> Save performance improvemented * fixed: If user Refresh or close Table Editor, it doesn't ask about saving changes if it exists but not applied * fixed: Copy columns names with columns types from Object window * fixed: If user selects name of DBObject and drag&drop it with ctrl for copying (standart function windows for copying), Edirot Object Window opened and copying doesn't happened * fixed: if press Open, for every window of SQL Window opened previous catalog, but its own should be opened Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.24.84 (23-Apr-2013) + added: DDL History journal on database or schema level (DBA -> DDL History) + added: Test Manager + added: Checking file changes for open file + added: Temporary tables and IOT in Objects Window have different icons now + added: Export into XML format from result grid in SQL Window + added: Support command line parameters: NoLogon NoSplash ShowConnectionList ReadOnly FullScreen ShowInvalidObjects ShowSessions SessionMode Connect OracleHome PrefFile CommandFile OpenObject QueryObject OpenFile Example 1: AltSQLDeveloper.exe connect=system/manager@orcl NoSplash FullScreen OpenObject=scott.emp readonly Example 2: AltSQLDeveloper.exe connect="sys/manager12@orcl as sysdba" CommandFile="D:\script.sql" Example 3: AltSQLDeveloper.exe nologon nosplash + added: rowid excluded from SQL export + added: Tools -> Preferences -> Export for specifying export DML and DDL settings + added: Tools -> Preferences -> Oracle -> Connection -> Session Mode + added: hot key F5 added as refresh command In Object Window + added: information about children nodes count added In Object Window + added: double-click on column border set true column width + added: After "Delete all records" command shows quantity of deleted records + added: In context menu of Object Window for heap tables added menu item "Change to IOT" for generating script for change heap table to Index Organization Table (IOT) + added: column "Indexed" added to Links For Object Window for grid Links To Object which shows exists indexes for foreign keys (it will easily determine which table which has cascade delete key can serve slow down when user delete a record from main table) * fixed: Sessions Window: if user doesn't have rights to switch pages with parameters it could raise an except * fixed: Sessions Window: when sorting doesn't change the settings for the tabs * fixed: default parameter sysdate extracts with apostrophes when user extracts DDL for table * fixed: code assistant doesn't work for dbms_sql.open_cursor * fixed: code assistant should show rowtype and type for symbol "%" * fixed: when we copy (Ctr-C) object name in Objects Window tree and when we paste it in editor name is pasted with new line symbol * fixed: code assistant doesn't work through pragma exception init * fixed: Oracle exception "check constraint violation" in SQL Window raise crashed the application * fixed: If dbms_output enabled and returning huge output data raise except Character buffer too small * fixed: If procedure/function/package/anonimys blocks has dml without commit, buttons commit/rollback don’t enabled * fixed: the application should informs about incompleted transactions and asks about commit/rollback before closing * fixed: Table editor show foreign keys, but Objects Window doesn't show foreign keys for the same table * fixed: double-click on invalid object doesn't open object editor * fixed: when user create a foreign key grid doesn't show primary keys * fixed: application hungs for 1 minute after ctrl-Space after typing a word "sys" * fixed: after added new object from object editor doesn't refresh Object Window objects list Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.22.74 (20-Mar-2013) + Added: Explain Plan Window: keys of SQL logs + Added: Explain Plan Window: display of error place + Added: Menu item "Change Window" in the context menu of the editors + Added: Reopen button in the main toolbar + Added: Menu items "Create Synonym", "Drop with purge" in the objects context menu + Added: Menu items "Rename", "Copy object", "Copy with data" in the tables context menu + Added: Menu item "Foreign key references" for the Table objects in the Objects window + Added: Ability to add bookmarks and jump on them from the context menu of the editor gutter + Added: The list of formats for saving files was expanded + Added: Ability to specify the date format for export + Added: Ability to select several entries in the "Find Database Objects" window + Added: Significantly expanded functional of window "SQL Statements History" + Added: "Test" button in the "Connection" window + Added: Column "Last connection" in the "Connection" window + Added: Shortcuts for Test Window debugging + Added: Ability to perform DML commands in the Test Window + Added: Function parameters hints by ctrl + shift + space hot keys + Added: Tools -> Preferences -> User Interface (Code Assistant) -> Parameters Completion + Added: Tools -> Preferences -> User Interface (Editor) -> Syntax Highlighting + Added: Tools -> Preferences -> User Interface (Editor) -> Use user regions (/ * region or - region and / * endregion or - endregion) + Added: Tools -> Preferences -> User Interface (Options) -> Saving windows when the application is closed + Added: In the Export Tables window possible to export to the clipboard + Added: Smooth loading of "Sessions", "Invalid Objects", "Find Database Objects" windows + Added: Context menu for columns for the grid of SQL Window + Added: In the "Find Database Objects" window option to specify search by names and source code separately + Added: Privileges for editors of users, roles, tables + Added: Items "Referenced by" and "Referenced from" for the types in the Objects Window + Added: Menu item "Query" for the pipelined-functions in the context menu + Added: Context menu for the results tabs in SQL Window * Fixed: Incorrect work with case sensitive names * Fixed: In Object Window doesn't work Rename command * Fixed: Apostrophe export from the grid in SQL Expressions Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.20.61 (31-Jan-2013) + Added: AutoReplace text, Tools -> Preferences -> User Interface (Editor) -> AutoReplace + Added: dialog for forming various SQL scripts when the user drags an object from the Object window into SQL Window + Added: opening the object when the user drags an object from the Object window in the empty area + Added: formats XML, CSV, DBF added in the Export Tables Window + Added: the ability to import from csv / txt, dbf, mdb / accdb, Tools -> Import Table Data + Added: the ability to export to the clipboard in the specified format added in the export data from a table + Added: description of functions added in the Code Assistent + Added: in the Explain Plan Window settings are automatically replaced with variables. This is useful when the user receives the request from the trigger or the Program Window + Added: Ability to set filters or sorting for the list of users + Added: the ability to group records in the grid and use the internal filter mesh in the SQL Window * Fixed: In search of database objects the "Status" param wasn't considered * Fixed: the script creation for the index wasn't include the tablespace in the table editor * Fixed: Creation of the new object with the master could call the "Object not found" error Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.19.58 (25-dec-2012) + Added: Connections Window + Added: AfterConnect.sql + Added: Template Wizard for new facilities + Added: "Print Screen" button to the toolbar + Added: in the table editor to editor Checks constraints added Code Assistant facilitates the writing and editing Checks constraints + Added: in the table editor context menu items added index "Analyze", "Rebuild" + Added: In the context menu items added to the object tree "Analyze", "Rebuild" + Added: Tools -> Preferences -> Compiler -> Add debug information when compiling * Fixed: Code Assistent sometimes ignore the cursors and variables in triggers * Fixed: Code Assistent sometimes do not consider variables such as a cursor * Fixed: the line number errors in triggers can not have the correct values * Fixed: In the formation of a script for IOT table has a primary key index * Fixed: does not save the values ??tab Tools -> Preferences -> Compiler Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.17.55 (10-dec-2012) + Added: in the Code Assistent can be added local variables, functions, types, cursors + Added: in the context menu of the "Search links for object" window was added commands Links, Delete all records, Truncate + Added: speed of work of "Search links for object" was increased + Added: in command from the context menu "Test" if the function has overloads is proposed to select the option window function + Added: in context menu Other in the Object window is added command Links + Added: in the Object window was added detailing of objects in depth of the tree (Synonyms, References, Referenced by, Granted to users, Granted to roles, Columns, Triggers, etc) + Added: in the Object window for the field of Search was added context menu to allow user to control the search settings + Added: Ability to copy the execution plan in Explain Plan Window + Added: in the Table Editor for Foreign Keys was added lists of the tables and fields + Added: in the Table Editor (Storage) was added information about indexes + Added: Tools -> Preferences -> Oracle Options -> Ping session every ... seconds for keepind the session in active statement + Added: in the editor`s context menu was added an item "Paste from Host Language" to paste SQL code from other IDE + Added: Improved integration of cache in the Code Assistent * Fixed: in the context menu of SQL Window command Truncate and Delete all records don`t indicate the schema owner * Fixed: in the Command Window in some cases ignored delimiter expression / * Fixed: in the Table Editor incorrectly displays the integer and float data types * Fixed: sometimes in the Table Editor the script for Check constaints can be form uncorrectly * Fixed: Table Editor doesn`t generate the script of change property Deferred for keys ------------------------------------------------------------------------------- release 1.16.53 (29-nov-2012) +Added: if user has download х64 version of the program but he doesn't have х64 oci.dll and he has х32 oci.dll, the software offers to download x32 version +Added: commands Purge and Restore for removed objects were added to the object tree +Added: commands Open and Query work for all selected objects in the object tree +Added: lines in the editor marks like saved if it is stored in a file or at the server +Added: added the ability to close unnecessary pages from the context menu of the page tab +Added: was increased speed of response of Code Assistant +Added: added user regions --region --endregion and /*region*/ /*endregion*/ Fixed: sometimes in the Invalid Objects Window doesn't work common key of executing Fixed: sometimes loading and deleting of recovery-file calles the error Fixed: the recovery mechanism is triggered if the second copy of the program is started Fixed: doesn't recovery the window caption at the recovery of the previous versions editors Fixed: parameter Temporary has no affect to the script in the Table editor Fixed: if user doesn't have the rigts to dba_users and tryes to open editor it calles the error of opening the editor Fixed: search text window at the second show started the search without key click Fixed: the sequences editor doesn't generate after script Fixed: the directory editor doesn't load the path Fixed: the object tree doesn't show the queue tables Fixed: in the debug mode wasn't shown the value of the variables like х.у Fixed: if user click on the name of the function, it is possible that the link goes to another function with the same name ------------------------------------------------------------------------------- release 1.15.51 (23-nov-2012) + Added: improved information content: if the server connection is lost and goes reconnect, the status bar displays a warning + Added: significantly increased download speed table editor with lots of keys + Added: The editor of synonyms list of available items for the selected user + Added: SQL Window when saving to a file name of the file is displayed in the title bar + Added: Backup file when you save the file + Added: recovery mechanism of open windows with the script for unexpected program shutdown + Added: Test Window, debugging scrolling only if the debugged line out of sight * Fixed: Window List not drag if you drag the panels for the inscription ------------------------------------------------------------------------------- release 1.12.50 (19-nov-2012) + Added: Tools -> Preferences -> Toolbar + Added: commands "Open" and "Drop" for constraints + Added: command "Open" for the index in the objects tree * Fixed: not always true formed script to create the index, synonym * Fixed: SQL Window script not correctly highlighted when switching between tabs when the script at startup has been selected * Fixed: SQL Window is not true show error place if the script at startup has been selected ------------------------------------------------------------------------------- release 1.11.49 (13-nov-2012) + Added: "Explain Plan Window" command "alter" available for execution + Added: "Command Window" support commands "View", "Edit", "Query" + Added: "Sessions Window" add buttons "Visible Columns", "Group by", "Turn", automatic updates * Fixed: "Test Window" at the test sometimes opens a wrong script * Fixed: double click in the object tree on the folder results in the opening and closing folders ------------------------------------------------------------------------------- release 1.10.44 (06-nov-2012) + Added: "Command Window" support command: SET AUTOT [RACE] {OFF | ON | TRACE [ONLY]} [EXP [LAIN]] [STAT [ISTICS]] + Added: Context menu in the "Sessions Window" + Added: "Test Window" Call Stack + Added: "Test Window" tab "Profiler" + Added: Window list write text in the window title + Added: Window list option Short text + Added: "Special Copy" for copy selected query for different IDE + Added: Error codes in messages with errors (eg ORA-... etc.) are now clickable, now links lead to Google, but will make setting + Added: For "Search database objects window" add indexes, comments + Added: "Search database objects window" works in separate thread + Added: in editor a lot of keywords highlighted * Fixed: Code assistant does not display hints for system aliases views * Fixed: "Test Window" does't show execution time * Fixed: "Package Window" in Code Navigator Test button does't work * Fixed: If you hold down the right mouse button and hover over the word is highlighted not only objects, but also reserved words Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.9.41 (22-oct-2012) + Added: Tab "DBMS Output" in "Test Window" + Added: BreakPoints in "Test Window" + Added: Context menu buttons "Test", "Add Debug Information" in "Objects Window" + Added: Tab "Statistics" in "SQL Window" and "Test Window" * Fixed: the shortcut icon is not signed by program name * Fixed: Sometimes a window with an error message is displayed without title bar * Fixed: A message box is displayed on top of all windows in all applications * Fixed: incomplete list of features package in the code assistant * Fixed: The program does not run on Windows 2000 * Fixed: After a single query in the "SQL Window" sorting in the grid is not reset * Fixed: In mode "Full Screen" does not return to Maximized mode, if it was before. * Fixed: the formation of the script on the button "Test" for a function or procedure if it is not in the package does not always give the correct result Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.8.39 (08-oct-2012) + Added: in the Code Assistant adds support for: new and: old triggers + Added: in the Code Assistant adds support for "self" to "type body" + Added: in the Code Assistant adds support for "nextval and currval" for "Sequence" + Added: in the Code Assistant adds support for variables and methods for the "Type" + Added: in the Code Assistant adds support for "@" to enable database links * Fixed: After installation and start application from installation process installer stay in memory * Fixed: "Object window" command "Refresh" does not work if the folder is expanded and there is not have children * Fixed: "Command window" self reconnects after the command "disconnect" * Fixed: a lot of small bugfixes ------------------------------------------------------------------------------- release 1.8.38 (04-oct-2012) + Added: "Test window" display return parameters and display the values of variables in hint + Added: "Test window" to the context menu added "Add Variable", "Remove variable", "Set the variable" + Added: In cache Code Assistant mode when an object dropped from the context menu is cleaning out of the dictionary object + Added: Tighter integration cache aimed at minimizing the communication to the server database ------------------------------------------------------------------------------- release 1.7.35 (01-oct-2012) + Added: button "Print" + Added: export tables to the opportunity to export not only through scripts, but also through the dump + Added: Tools -> Preferences -> Oracle Options -> NLS_DATE_FORMAT for set NLS_DATE_FORMAT on sessions after connect * Fixed: "Procedure window" sorting procedures in the tree ------------------------------------------------------------------------------- release 1.6.34 (29-sep-2012) + Added: Cache mode for Code Assistant * Fixed: removed session pool ------------------------------------------------------------------------------- release 1.6.31 (19-sep-2012) + Added: in Connection Window if password is not stored then show dialog for request password + Added: Session -> Change Password * Fixed: Command window tab key was not perceived as a separator for commands ------------------------------------------------------------------------------- release 1.5.30 (17-sep-2012) + Added: in the Sessions window added tab "Hide", which allows you to collapse the panel with more information on the session, and in this mode with this window is faster due to the fact that no additional information is requested from the server database + Added: SQL Statements History window + Added: in Table Editor tab "Data" button is added to "Refresh" + Added: in the links for object table is now displayed to the selected user + Added: button "Test" + Added: button "View" and "View data" to display the objects in a mode Read-Only, the default option is to display these buttons disabled, set in Tools -> Preferences -> Objects -> Show context menu items for "Read Only" mode + Added: "Tools -> Preferences -> Objects -> Always add owner name for Open & Query commands" regulate or not to add the name of the owner of an object when it is displayed (if owner is same as logged) + Added: if no text is selected, and the cursor is inside a comment the command "Selection Uncomment" uncomment this comment block + Added: transitions to database objects by Ctrl-LClick and Ctrl-RClick. * Fixed: in the "Hot keys" window keys "up" and "down" are defined for Grid scroll * Fixed: the editor table is not formed right script for indexes * Fixed: when changing the connection requests for objects from the object can be queried multiple times Other minor fixes and improvements ------------------------------------------------------------------------------- release 1.4.28 (11-sep-2012) + Added: in the command window adds support for command "show" with the parameters "user, parameters, spool, spoo, sqlcode, sga, recyclebin" + Added: tab output for SQL Window + Added: settings in the Preferences for tab Output in SQL Window * Fixed: support minor versions of Oracle ------------------------------------------------------------------------------- release 1.3.24 (10-sep-2012) + Added: the ability to create custom folders in the Objects Window settings with the ability to query and icons + Added: Files window for quick access to frequently used scripts + Added: Tools -> Preferences -> Editor -> "Keyword case", "show special chars by default", "Wrap Lines" + Added: (MainMenu) -> Edit + Added: display errors for objects in Invalid object window + Added: display additional information about the session in Sessions window ------------------------------------------------------------------------------- release 1.2.23 (06-sep-2012) + Added: Tools -> Preferences -> NLS Options -> Date + Added: display bookmarks in the editors + Added: users with rights to sys.dba_users can see in the object tree different icons for locked or blocked users + Added: contex menu in Invalid Objects window (Open, Recompile, Drop) * Fixed: if the IDE starts running associative load these files do not connect to the database for quick access * Fixed: call command "sqlplus" in command window * Fixed: formation in "user script editor" window * Fixed: not always asked to confirm the deletion of objects * Fixed: recompile synonyms in invalid objects window * Fixed: at successful recompiling in invalid objects window to not change the status icons of the object * Fixed: subquery could cause an error when you do not go well defined list of tables used to display information about the columns * Fixed: maintaining connections with direct mode with different SID kept in one record ------------------------------------------------------------------------------- release 1.2.22 (04-sep-2012) + Added: in window Links For Object added context menu with items "Open", "Query", "Drop", "Enable", "Disable" * Fixed: sometimes don't work commands Open&Query * Fixed: indent output data in command window * Fixed: search in object window sometimes found only the first value * Fixed: when changing databases do not always show up in object window if the save layout was exhibited another ------------------------------------------------------------------------------- release 1.2.21 (03-sep-2012) + Added: the ability to increase / decrease the font size "ctrl + scroll mouse wheel" and by "shift + 0" (zero) return the size of the font in the default settings. This function can be completely disabled in Tools -> Preferences -> Editor + Added: Window Links for object (you can specify the table and see references to this table from other tables and which tables referenced by this table) + Added: in sql window is Added button "links" where you can select the table for which should be showed connections by the keys + Added: in Preferences Added a new option of accounting for the output of the code assistant synonyms + Added: code assistant shows field of views and synonyms + Added: Added ability to display images from database in the value editor + Added: time of the query in the sql window is displayed in a separate field * Fixed: in Preferences can't be asked for font of editors * Fixed: Incorrectly display some specific types of data in the table editor * Fixed: in Editor synonyms fixed formation of the script for the current user * Fixed: uncorrect display of xml field in the sql window * Fixed: code assistant window did not allow the height of the parent window * Fixed: Error in creating of secondary key in the table editor ------------------------------------------------------------------------------- release 1.1.20 (30-aug-2012) + Added: window of export tables + Added: In preferences added ability to specify indent and tabs mode for editors + Added: Data tab is added to table editor + Added: added the possibility choice of additional tabs for table editor + Added: In the update window added button Download and install for not have to visit the site for updates * Fixed: uncorrect work of generating script for index-organized table * Fixed: do not appear roles for user with standard rights * Fixed: do not allow change of type for table editor * Fixed: not always apply user style grid * Fixed: an error if sql expression starts with a left parenthesis * Fixed: in the grid where you can select multiple rows appears only one record