Recent content by jhughes

It is mentioned via Help -> User's Guide from the GUI. Section 3 is "Logging on to an Oracle database"

Never did ask this last time, but if you have a .xml file saved on disk and double click it, does it open in Notepad++?

I tried it using the same PL/SQL Developer version 15.0.4.2064 against an older Oracle 12.1.0.2.0 DB. I did NOT encounter any issue. I used the Command window to run the Create statement. I used a single SQL Window to run both statements and I left the first Explain Plan window open.

Configure -> Preferences -> Options (under User Interface in left pane) -> "DSA Dialogs..." button at bottom on right.

Check the "Don't show this message again" checkbox before clicking the No button. I still find it odd that Notepad++ won't start up via PSD if you have it associated at the OS level. Reference: Your action will put View.xml=7 into the DSA file.

Here's how PL/SQL Developer (PSD) interacts with a column that shows in it for me. When I click the three dots, I get a pop-up asking ** View column data externally as "Extensible Markup Language"? ** with the Yes/No buttons and the Don't show this message again checkbox. If I click No, the...

Assumption: You are using Windows. If sounds like you have nothing defined to view a .xml file so Windows doesn't know what to do. If you have a .xml file on your machine (desktop or any directory) and you double click it, what happens? Does it open in some software program or do you get the...

When the first /* is encountered, Oracle begins ignoring all subsequent text until it finds the first occurrence of */. Oracle doesn't "see" the second /* as it is within a comment, which Oracle is not syntax parsing. Once the first */ is encountered, Oracle resumes syntax checking. It runs...

Create a scenario that can reproduced by others. By that I mean, create a new table, insert some rows (say 4), write the SQL statement that reproduces the sorting issues you are seeing and share that with everyone here. This means you will have a CREATE TABLE statement, x number of INSERT...

I don't know of a way in PL/SQL Developer to do the searching you are asking about, but that is also because I tend to use the various Oracle provided views for such searching. I write queries against all_objects (or dba_objects) to find where an object is (or defined as). Similar I query...

To add to point #1, I do miss the color variations of v14 and prior in v15.

Good to know on the params.ini locations. I will admit my approach is a bit of a leftover from before Instant Client existed and you had a full client install on your machine. It works so I continue with it though as it is seamless when upgrading PL\SQL Developer to a new version on the same...

First I'll state that I have Admin rights on the laptop I use, though I've helped a co-worker get the same setup going on his machine and he didn't have Admin rights to his machine. And by that I mean as our company has his non-admin account defined as, not as your company may have setup. We...

When you say "Oracle 12 installed" and "fresh install of Oracle 19" do you mean the full DB or the Instant Client?

I would question what you see via *_SOURCE for Oracle supplied code in general. Again, you should not be transferring Oracle supplied code/objects from machine to machine in this manner. If this problem were to happen to user wrapped code, then I agree that Marco should look into it as a bug...