Recent content by zakko

The "combined tab layout" (via STRG+Click on result tabs) of result sets colapses after a connecting into a new session and reexecuting the given selects. To my understanding this should only be a display/layout task and has nothing to do with any connection/db/session related thing. So I...

In tab view, if I do a right-click on the tab title with the file name and select "Rename..." an input field to change the name pops up as expected. But this renaming doesn't affect the actual file nor the entry in the list of project items, if it's stored in a project. This seems quite...

It would be a good imporvement to make packages (and functions, procedures... everything, that is placed on the filesystem), that are stored in a project, renameable (item and file) via the project items view and from menu project > project options, tab Items. Currently - as far as I see it -...

I'd like to suggest a new search scope "current function/procedure". In case you search e.g. for variables in a specific function/procedure in a larger package, it might be useful to reduce the search scope to this function/procedure only (taking the cursor position into account for evaluating...

In a standalone procedure or function there are folder-like objects displaying its high-level structure like "Declaration", "Codes Section" etc. Currently, if you select A-Z sorting, these generic "structure items" will also be sorted. I think this is confusing and only the objects like...

I just recently struggled with a larger function that has lots of variables declared. I couldn't find a way to put these in alphabetical order. It would be a good enhancement, to provide a possibility to get an A-Z order also for the variables in the code contents.

There is an issue with viewing the full column comment in "describe window". 1. Open "describe window" of a table with a column comment exceeding the length of the given content space. 2. Mark/select the row with the column's metadata and the long column comment 3. Select the "..." button for...

There seems to be an issue with setting bookmarks in a split program window. Here are the steps to reproduce: 1. Open PL/SQL package in single window mode. 2. Split window (drag window separator from top window border) 3. Set bookmark in lower part of the window: Bookmark with index 0 is set...

It's currently not possible to bulk rename savepoints via right-click > Refactoring > Rename Item. This should be added to the bulk-renamable items. Version 15.0.4.2064 (64 bit) Windows 11 Build 22631

No, unfortunately I can't share the original code, but I made a few changes to have it as close to the original as possible. I recognized, I missed a detail. The update is part of a forall, like so: forall idx in 1..textArray.count save exceptions update books set startText = null where...

The following update statement in PL/SQL code produces a compiler warning in PL/SQL Developer: UPDATE employees SET commission_pct = NULL WHERE job_id = 'SH_CLERK'; It says Hint: Comparison with NULL in [procedure name], but it is obviously not a comparison. Version 15.0.4.2064 (64...

Here's a suggestion for a small enhancement on the AutoReplace file-management at Configure > Preferences > User Interface: Editor > AutoReplace: There should be a setting (probably a checkbox) to let the user decide to overwrite the current AutoReplace file without further prompts. Adapting...

Let's assume the following merge statement in PL/SQL code: merge into table1 a using (select data2, data3 from table2) b on (a.field1 = b.data3) [...] Observed behavior: Code completion doesn't kick in and suggest fields of tables a and b in the on-clause while initially writing the...

Let's assume a cursor for loop like this: for text in cGetAllLines loop [some code using text] begin [some code using text] exception ... end; end loop; Observed behavior: At least within a additional begin-end block, the row variable "text" is not recognized by...

The collapsing of subprograms is faulty or at least not very intuitive. This should be improved. Let's assume the following function with suprograms: function mainFunction return number is var1 number; function subprog1 is [code] end subporg1; procedure subprog2 is [code] end...