Recent content by Hilarion

Your original problem might have come from the fact that your script was actually incorrect - it did not contain correct separators. As with Oracle SQL*Plus (with default settings), the PL/SQL Developer uses semicolon (";") to indicate end of a SQL query/command, but as the semicolon is used...

Or you can see (or change) what is defined for "SQL Window: Execute current statement" key binding at: Tools \ Preferences \ User Interface \ Key Configuration The "SQL Window: Execute current statement" is the last position on the key binding list there, so it should be easy to find. If you...

As far, as I know, this is a feature you can use to export query result to MS Excel without loading the results first to the grid. In case of a query that returns first rows fast, but has a lot of data, you can execute the query to the grid, to take a look at the first rows, and then use the...

Many applications that have this feature do introduce an option for that (so you can choose if the application allows the system to open a new instance for a document, or the application should force it to be in one instance). The case when you have multiple instances open (which is not actually...

That's actually not entirely true. The NLS_LANG specifies how (and if) will the Oracle Client re-code the VARCHAR2 values for the application that is using the Oracle Client. There's a silent (and sometimes incorrect) assumption, that the application is using the same encoding, as the underlying...

At my previous employer we had a 100-licences pack (with support) and it seemed to change nothing. Due to low support quality (as indicated by various devs) my current employer is rather leaning to using Oracle SQL Developer and PLD (or TOAD) only in cases where specific developers press on...

It seems that PLD is not able to find and/or parse your tnsnames.ora file. The question is: did you change anything in that file since earlier version of PSD?

What if you add "C:\Oracle\product\instantclient_12_1" to PATH environment variable? (If you have any Oracle Clients already in PATH, then make sure that this one is first in the PATH.) Edit: You may actually have to add two paths to PATH variable: C:\Oracle\product\instantclient_12_1...

Actually some applications handle this internally. When application is invoked, before it opens a visible window (or performs any other visible operations or time/resource intensive tasks), it: 1. checks if it's configured to work in single-instance mode (and if no override for this setting was...

The "Pin window connection by default" only affects newly open windows, so if you did play with it after opening the windows, then it had no effect on them. The only way you can change the window behavior in that aspect, after it was open, is to manually pin (or unpin) that window. If you'll...

At my screen size and resolution the toolbar size is just right, so it should not be simply changed. It should either scale for the chosen DPI or the user should have an option to adjust it's size, or - best - both solutions should be there.

As I wrote, you do not have to have admin privileges to alter your personal file type handling registration (unless you are on Windows XP, 2000 or NT). The fact that the PLD does not have a UI for it and that Windows does not have a good UI for it, does not mean that the feature is not there...

I'd rather opt for it to work in a similar fashion to what works with SQL*Plus, so not the "last @ sign", but just quoted identifiers. That not only goes for passwords, but also for user names (as those also can have special characters in them, e.g. the "@" sign or the slash "/").

OK. To make things more clear, the problem (beside small rounding differences) is that when scientific notation kicks in (rows numbered from 10 upwards), do not show the exponent value when "numwidth" is low (e.g. 12). For me it was easier to notice it when I actually made the third column to...

The Test Window does allow you to execute plain SQL queries with or without bind variables. In this case you have to remember not to include the trailing semicolon. The results will be shown in the "SQL Output" tab and it will not be paged (e.g. all data will be fetched). The Test Window does...