Recent content by Rahul P

Eg: SELECT SUM(COUNT(*)) over(ORDER BY case when 'X' = 'X' then null else dbms_random.value end) FROM dual; Does not beautify. But this does. SELECT SUM(COUNT(*)) over(ORDER BY dbms_random.value) FROM dual;

Is there a workaround for this issue? The UTF-8 isn't being saved with or without BOM. Please help.

Hi, Feature request: Love the compare records' 'compare whole record' enhancement. Stops us from not having to write a bunch of GROUP BY sql potentially. Just like the subject said, I was wondering if we can get a Preferences setting for SQL Window to have the 'Compare Records' SET so that we...

Save with BOM (Unicode Byte Order Mark) is SET (checked).

Hi, We moved to Version 11 and I see that the PL/SQL Developer Program is not keeping the UTF-8-BOM setting but, instead, saving the file without encoding information. What are we missing? This is a major issue for us, since, every time we save a file, even though there are no changes, our...

Opened a new instance using Windows Explorer also.

Hi, Is there a way you can limit the PL/SQL developer to one instance only? Here is my reason. We have a source control called Mercurial. In it's setting, I put the default viewer for the package files to be pl/sql developer. So, when I open the file from Mercurial, it fires up a *new*...

I have a follow up question. When I setup the date to to_char setting, I am not able to get the time element in the date. How do I go about getting that information? The NLS setting does have time in the date format.

Works perfect. Thank you.

Hi, We have a Heterogenous Service database link setup to connect to a sql server database from our Oracle instances. Whenever I query a table with date column in there, it gives us junk data. I tried messing with various settings including NLS but, to no avail. It is the same with both the...

Yes, that is what I did. Luckily the compiled code was in the database and the production backup was taken yet. Serves me right to not have synctoy setup on that folder. Thank you for your inputs. Once and when it works, I will incorporate the command line interface for our developers to use...

Also, if I remember it right, the file contents were gone in the first command itself. When I got this error message: Failed: PL/SQL Beautifier could not parse text

Marco, I have a real issue right now. I tried the beautifier from the command line in plsql command window and it wiped out the whole file contents. Anyway I can get it back? I don't have a backup of this file. SQL> beaut C:\Users\Fill1\om_*****.bdy Beautifying file: C:\Users\Fill1\om_****.bdy...

We are implementing Mercurial as our source control solution. I love it but, unfortunately doesn't have integration with PL/SQL Developer, but, I digress. One of the things I wanted to see if we have a command line interface for the PL/SQL Developer's beautifier tool. This would help in making...

Marco, I checked again and all the associations are right both in windows and pl/sql developer. This used to work fine in my older Windows XP 32 computer fine. But, I have a 64 bit Windows 7 running this 32 bit application. Could that be the issue?