Recent content by Buckeye

My tst files where opening in the existing instance but my sql files where not. I looked in the Windows registry and changed: HKEY_CLASSES_ROOT\.sql data to PL/SQL Developer Now the sql files open in the existing instance! I first looked at the .tst entry to see what it looked like. Windows 7...

Do you have a link to download the last version 8 of PL/SQL Developer?

I copy to Excel all the time. I am disapointed that we now (version 9.0) have to slide over to chose xls or xlsx. In my opinion it would better to replace "Copy to Excel" with "Copy to Excel xls" and "Copy to Excel xlsx".

Has this been added yet? I don't seem to be able to get it to work this way.

I know how to type it out properly....the point is that the PL/SQL Developer GUI doesn't do it correctly. Thanks for trying to help.

I've had a table inadvertently created by another program where the owner name becomes part of the table name. For example: owner: XYZ table: ABC.TABLENAME When I right clicked on this table in the browser and dropped it (connected as user XYZ), this table was dropped instead: owner: ABC...

In the code assistant for a table, it would be very helpful, and use little space, to be shown if the column is nullable or not. The default value might be nice too for some people.

I have been using PL/SQL Developer for about 2 years. I use it daily mostly for ad-hoc report and investigation work. I have posted several questions on the forum and have received timely answers. One time I found something in "copy to Excel" that didn't work as it did in an earlier build. I...

It (6.0.5.943) is working great! Thanks.

In the SQL results grid it shows everything between the : 6.0.4.906 put the same in Excel. The cell has "text" format. For the formula to evaluate in Excel, I have to change the Excel format to "general". 6.0.5.942 just puts in Excel.

Marco, I tried it and it sent data to Excel but didn't do the formula cell the same way 6.0.4 does. It only put ="R" for the formula. Randy

I found a backup I had of the 6.0.4 setup so I went back to that version. Now the SQL results for the SQL in the previous post copy to Excel just fine.

I figured something out...this SQL used to work. Now it seems to be having trouble with the xNEW_FIN_CELL column in which I am building a formula. fin_cell contains a cell reference in the RxxCxx format (ie: R10C3 which is the same as cell C10) The output of this column looks like...

The "copy to excel" function seems to end normally. Do you think it might help to uninstall PL/SQL Dev. and do a clean install? Are there any folders, files, registry entries I should make sure are removed before installing again?

I have occationally had trouble using copy to Excel from the SQL window results. It creates an xls file in the temp folder but does not open it. When I try to open it myself, Excel says "unable to open file" and "Errors were detected in 'tmp001.xls,' but Excel was able to open the file my...