Recent content by pwo1433

Hello Marco or anyone, Any ideas yet ? " We remain very interested in a solution too. We are on Oracle 10.2.0.3 with PL.SQL Dev. 7.1.4.1389 and experience 2 very, very slow responses (several minutes each): clicking on the + on Tables in the Browser window and on entering the period (.) after...

William, your code may be helpful to me. Where do I find my 'sid' ? Thanks. Paul

We remain very interested in a solution too. We are on Oracle 10.2.0.3 with PL.SQL Dev. 7.1.4.1389 and experience 2 very, very slow responses (several minutes each): clicking on the + on Tables in the Browser window and on entering the period (.) after the schema in the SQL or Command Window...

Can we have 2 versions on a pc at the same time ? We wondered if that would cause problems. Thanks. Paul and Ron

Actually, Marco, you can cancel this question. I see that all we need do is clear the results and THEN click export and the sql code results are exported and NOT what was in the results screen. We are ok then. Thanks.

In the first scenario, just change the query and don't run it then (where the results come back to the screen), but just click on the 'Export Query Results...' button and immediately send output to .csv (while the results of the first query are still sitting on the screen). In the second...

When you run a query and bring the results back to the screen, then make a change to the program and rerun the program exporting the results to a .csv file, it actually exports the results of the program you ran BEFORE the change. You have to change the program, bring the results back to the...

We have 7.1.4.1389 and use Oracle 10g DB. Clicking the + on Tables in the Browser takes very long (several minutes) to return the tables. Other staff here still have versions 6.0.5 or 7.0.3 and the Tables refresh in seconds. On the 7.1.4.1389 we have the 'noqueryhints' parameter installed but...

We have found the problem is not related to anything of PL/SQL Dev. or Oracle, but is caused by a config problem in a security tool "Digital Guardian". Our techs changed that config and the problem is solved !! Thanks.

(From Ron E (It wouldn't let me log in the past couple days) When it locks up, PLSQLDEV.EXE has 99% CPU usage in Task Manager, using about 39,825K memory. Performance shows 2 gig memory, 1,343,000 available, cache 1,494,900, handles 9772, threads 536 processes 43. Ron

The highlighting of matching parentheses is one of the best features of recent releases, but try this code in both the SQL Window and the Command Window. select a.* from aaaaa a where not exists ( select null from bbbbb b where a.id = b.id ) The matching parens...

I get this too on 7.1.4.1389. Try changing the shortcut to something like: "C:\program files\plsql developer\plsqldev.exe' noqueryhints See if that helps. Marco has suggested that for some similar issues. Marco?

That will be great, Marco. We will watch for 7.1. Thanks.

Several programmers/users have asked me to forward this question ree: SQL Window operation: (we use PSD 7) PSD 6 let you select the "Export Query Results...." before you even F8. That way you could direct the results to be saved, then press F8, and then go on home. PSD 7 doesn't even show that...

OK. Thanks everybody. Paul