Recent content by UMG Developer

Is there a way to export to a CSV file but without the header row containing the field names? (It isn't a huge deal to edit the file and remove the header row, but it would be nice if we didn't have to.)

When I try to use the PL/SQL Beautifier with CTEs it doesn't work, here is an example that gets the "PL/SQL Beautifier could not parse text": WITH "TestCTE" AS (SELECT * FROM dba_jobs) SELECT * FROM "TestCTE"; But if I break the line at the first SELECT, and then select the text up to the last...

It would be great if you could fix it as part of the 8.0 release, because in the data we get the date portion is 1/1/1900 if only the time portion is supplied, but sometimes the date is there, and we need it too.

Using the Copy to Excel with "select sysdate from dual" does work for me, but "Select from Table" does not. (The field is of type DATE.) Try this script: CREATE TABLE Test (TestDate DATE); INSERT INTO Test VALUES (to_date('01/01/1900 3:05:00 PM','mm/dd/yyyy HH:MI:SS AM')); SELECT * FROM...

When I run a query, select the results and then use the "Copy to Excel" function, it appears that the time portion of Date fields is truncated. In PL/SQL Developer the field shows as: 1/1/1900 9:06:00 AM Excel shows: 1/1/1900 (and I checked that it isn't just formatting) If I just use copy...

But it could run the query in a separate thread that didn't block the UI from updating. (When I execute a normal query that takes 10 minutes to run, it doesn't block me from editing in a different SQL window when it is running, why does this query?)

For now I guess I can take the statistics out of my view, but do you think it is something that can be resolved in an update?

Normally about 0.875 seconds according to the status bar.

I think I found the actual cause... In the bottom section have the "Statistics" tab selected, and then when the window updates everything in PL/SQL Developer pauses for a second or two. (Or at least it does for me.)

I am in "Multi Session" mode.

If I have a Sessions window open, and I have it set to auto refresh, it appears that every time it refreshes that everything in PL/SQL Developer freezes. (Going through menus, or working in other editor windows.) It would be nice if it didn't freeze up while background tasks were running.

I just resent it zipped this time, let me know if you don't get it. (The file was only 340k, so I wouldn't think size was a problem.)

Marco, I sent the debug log about 3 weeks ago, and I haven't heard anything back, did you get the log? Where you able to identify any potential causes?

If I use the PL/SQL Developer interface to create a bitmap index on a partitioned table I end up with this error: ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables It would be nice if PL/SQL Developer was smart enough to notice that the table was partitioned, it does...

I think the FTP plug-in is great, but so far I have found a few small changes that would make it even better: * It would be nice to be able to add an "FTP Open" button to the toolbar. * When you do a "FTP Save As..." have the file name default to what the current file name is. (The normal "Save...