Recent content by petesmith

It is set to the default 'Automatically Determined'. I like it that way as it uses the results grid height to determine the number of records to fetch.

Hi there, Just a minor thing that I've noticed several times that can be annoying and could be fixed. If you do a query in the SQL Window in PL/SQL Developer 7 and now 8 and it fetches only the first 10 (for example) rows in the database it sizes the columns in the results grid based on the...

The 'Color Coding' feature is already present. Look under Preferences/User Interface/Appearance/Connection Indicators. I use Red for my Prod databases, Green for my Dev databases. Cheers, Pete.

Yes, this happens for me too, and has been painful in the past. However I don't believe this is a bug. It is a PL/SQL beautifier, not a SQL beautifier. A create or replace DDL isn't a part of PL/SQL. I do the same as above, I highlight the SELECT part and beautify that. It would be a nice...

I've worked around my issue by placing a '--' and a manual line break wherever I want to force the beautifier to break the line. The comment notation means that the beautifier cannot place anything after the '--' on the same line otherwise it will turn the code into a comment, so it has to line...

Me too. PL/SQL Developer 7.1.5.1398 doesn't beautify correlated update statements of this form correctly - The initial col1,col2,col3 etc. string doesn't get split at the commas. I don't think such statements can be converted to the form that the previous poster suggests, and probably not in a...

Ha! Its true - soon I'll be writing in the forums about how to do SELECTs! ;) I've set this variable many times in the past but didn't twig it would resolve this one.. Anyhoo, I set TNS_ADMIN in the environment, and cleared the Oracle Home setting in the options. PL/SQL Developer picked up...

Thankyou very much gentlemen - this looks like the solution I'm looking for. I'll give it a shot tomorrow. Cheers, Pete.

Is there any way to specify the location of a custom TNSNAMES.ORA in PL/SQL Developer? I started work at a new Oracle site today where the common PL/SQL editor of choice is TOAD. The site has a convention of rolling out TNSNAMES.ORA automatically to each oracle home, with a custom set of SID...