Recent content by wbennett

In the "Export User Objects", there is the option to select the "User" (schema) from which to export. Can you please add this to the "Compare User Objects" and the "Compare Table Data". We don't have access to the password of our main schemas (DBA controlled). We just have grants to those...

The results grid of the SQL window where you view/edit the data. In edit mode, you see a combobox when the column is a foreign key. In view mode, however, this is not visible. We are currently normalizing our tables and adding a lot of code tables. It would greatly help when viewing the data...

Can you please add "Explain Plan Window" to the list of available windows in the "Window Types" section? Thanks.

Can you enable the combobox for foreign key lookup in the SQL view just as in the edit view? Even better still, can you add column hints on the columns to show the code values?

Min/Max does not work for dates either

I've had this problem also. Have not yet determined how to reproduce.

D27111: :mad: I have put messages on this board with SQL in caps. If you have an opinion that is fine. Do not try to insult someone else while expressing your opinion, however. There are actually very valid reasons for using all caps in some cases. In Delphi 4, and probably some other...

Marco, Your "b" solution is what I'm asking for. Currently it does NOT allow you to select the Explain Plan window as one of the types that this "Tool" is enabled for (on the Options tab). I have my "Session Mode" set to "Multi Session". If I run the command from a SQL window, the Explain...

I agree with vladzak. I use commas in the front even in procedure calls in Delphi. I find that a lot of developers don't fully understand the benefits of block select and paste. Combine commas in front + block select + lining up common elements, you save loads and LOADs of time!

Ability for windows to have different logins. This is one of the disadvantages compared to TOAD. Currently simultaneously viewing multiple schemas requires multiple instances of the application.

Would like to be able to right align comparisons in the where clause. e.g. SELECT * ..FROM EMP .WHERE COUNTRY.........= 'US' .....AND EMP_ID.......... 2 .....AND FIRST_NAME.....= 'john' .....AND DEPT_ID.........IN (2, 3) .....AND LAST_NAME..LIKE '%es' .....AND BDATE..BETWEEN '20-May-1920'...

Would like to be able to export objects of a schema other than the one that's logged in. Don't always have the password for the other schema to be able to log in.

When auto executing SQL using the little circular arrow at the lower left, how about adding the timestamp of when the command executed in the statusbar also.

Request that the tools options support the Explain Plan window type. e.g. Our database has different schemas for different countries with the same table structure (don't ask why). The first thing that is done in the session is changing CURRENT_SCHEMA: if country_cd = 'US' then v_schema...

This problem appeared in PL/SQL Developer also. The Fix: Set OCI mode to 7. This seems to occur when you have OCI greater than version 8.0