Recent content by Joe Simunac

OK, this only seems to happen if the CASE is inside an SQL statement. Stand alone CASE statements work OK (although there is no way to configure how I want it to look), but inside SQL they just show up all on one line and word wrap if they get to the end.

I know this has been requested many times, but why doesn't the beautifier recognize and handle the CASE statement. That statement has been around for years and you still don't handle it. In v9, it at least put the various clauses on separate lines, but v10 just word wraps. I can't even format...

The new version looks really nice. But there's still one thing that bothers me - there is no way to set the directory for Import definitions. You can set everything else. We prefer to keep our import definitions on a network drive and it's annoying having to go to it every time. Still, I'm...

We're testing all of our software on a Vista machine and have run across a strange problem. We use Oracle Instant Client and have always had to type in the Oracle Home and OCI Library in order for PL/SQL Developer to work correctly. I did the same under Vista, but when I restart PL/SQL...

Great. That explains why I couldn't find anything. Thanks. -Joe

Our DBAs are converting from Local Naming to Directory Naming for connecting to our Oracle DB. This works fine in SQL*PLUS, but I can't figure out how to set it up in PL/SQL Developer. We have a few copies of Toad 9.x and it gives you the choice of TNS, Direct or LDAP. Is this possible in...

We've got a maintenance contract as well. Plus my request to sales was about buying more licenses. I assume if they'd seen it that I would have had an answer. It's probably a spam filter, but I'm not sure if it's on their end or ours.

I'm not sure if I'm having the same problem or not. I've tried to contact sales (about a possible upgrade) and support (trying to get a password that works for 7.1) and have not had a response. The emails have not been returned, but usually I get a response within a day. It's been over a week...

I have a procedure that returns the results as a ref cursor. In previous versions (I'm now on 7.0.2.1076) when I opened the cursor I could select the items to export and right-click to copy to Excel. In the current version I only have Clear or Clear Results as options when I right-click. If I...

There seems to be a problem with beautifying the CASE statement in certain cases. Here is my example: update tabname set code1 = case code2 when '5' then '1' when '6' then '2' else '3' end; I think this should display as: update tabname set code1 = case code2 when '5' then...

Yes, it does. The line is: P:\BusTech\Parking\holdtix.txt=C:\Program Files\PLSQL Developer\Import\Parking.def There is only one line and I've imported twice. Is that normal?

Yes, I've already imported. I saved the definition on exit after the import.

According to the documentation, if you save a definition in the text importer it will open automatically when you open the same text file again. I've set up my definition of the text file and the Oracle table to load into and saved the definition. If I open the same data file, the first tab...

I just tried to use the SQL function on the text importer for the first time. According to the documentation, you can enter anything that can be processed by Oracle. I had a list of SSNs and wanted to get rid of the '-'. So I typed: substr(#,1,3)||substr(#,5,2)||substr(#,8,4) It recognized...

Any idea when there will be a version of Query Reporter that works with the new 10g Instant Client? I've PL/SQL Developer working by changing the settings in Preferences/Tools, but there is nothing similar in QR. Thanks for your help.