Recent content by B_P_100

Marco, FWIW, I'm looking forward to the 64-bit compatible version. When I see the public beta I will renew my support and download it. I have to build a new development environment and I'd like to do it cleanly without the dual home nonsense... Cheers

Ok, the Explain Plan window is much less functional than the SQL Window and behaves totally differently. I tried to run the following in that window (after figuring out that I had to remove the trailing semi-colons): ------------------------------------------------------------------ --alter...

Altering session within Explain Plan Window does not seem to work for me. If I execute the following in the Explain Plan Window via F8 alter session force parallel query parallel 8; and then follow that by refreshing the query's plan via F5 then nothing changes in the plan.

Fyi I am using Version 10.0.4.1708.

I am trying to debug a complex query. This problem involves parallel query. Using the SQL Window I attempted to modify the session by issuing commands such as -- toggle to enable parallel alter session force parallel query parallel 8; -- and then toggle to disable parallel alter session...

Ok. Seems to work fine with 10.0.3.

Hi, A long time ago a user posted a message on this topic. #35671 - 09-24-2009 01:52 Problem with DBMS_OUTPUT He was using an earlier version of PL/SQL Developer and Oracle. I am using Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 with PL/SQL Developer Version 9.0.0.1601...

Please discard this. I just had my tnsnames.ora set up incorrectly. The service_name was incorrect (didn't have the blah.blah.com suffix). Thanks

I have a problem and I don't think it is specific to your product - I have probably set up my environment improperly. However you get many questions on this topic so you may be able to help me. I have a new Windows 7 laptop and I'm running a 64 bit 11gR2 database on it. The database and the...

Thanks Marco. Keep up the good work on the product. Cheers, Brian

Does PL/SQL Developer 9.x have built in support for displaying the relatively new Real-Time SQL Monitoring feature (available in Oracle R11). It is exposed in the latest versions of Oracles's SQL Developer tool. This feature seems to be an enhanced Explain Plan type of thing and it seems like...

I just installed v9 and the preferences are back at the default. I have tweaked many prefs in v8 and I'd like to know if there is an easy way to import all the modified preferences to the new version. Tks, BP

Hello, In the SQL Window there are three icons on the right side. These allow Previous SQL, Next SQL, and 'Export Query Results...'. The icons occupy a strip running down the right side of the window that probably takes the space of about 5 characters. Horizontal space for code is a valuable...

Thanks. I was able to solve the problem with your advice.

I am running PL/SQL Developer 7.1.0.1337 over a 10.2.0.2.0 database. I have a simple table containing a column with a datatype of TIMESTAMP. When I attempt to select from this table using the SQL window (or command window) I get error: ORA-03115: unsupported network datatype or...