Recent content by Jean-Paul Finne

Wardy is right. I find it inconvenient to add tables from the left list instead of selecting a foreign key column and have a list of tables that are joined to and from it. You have all the infos in the Sql/window with the linked query button. When are you going to add the following features...

I have the problem for all the foreign keys to the same table. All other foreign keys work ok. I removed the foreign key and recreate it. I still have the same problem. The work around works. "Show dictionary info in result grid" should be 2 options: one to display the info on the status bar...

Hi, I have a systematic hang of pl/sql dev. It happens in a sql window in query by example or edit mode. The editor should show an arrow on the right side. Instead the cursor becomes an hourglass and pl/sql dev freezes. The cpu usage is 100%. Is it possible to disable the auto-search of...

What about the query builder and ansi join ?

Are you going to put more feature into the 6.0 release ? Overall I'm happy with the beta. Nevertheless the 2 things I tested first are missing. 1) Handling of (left-right-inner-outer) join in the query builder. We only use the new syntax (new for Oracle...) and the query builder is unusable...

I have different behaviour with query by example when I enter A in a varchar2 column. On some machines it generates :deptname like 'A%' On another: deptname like 'A' even sometimes:deptname = 'A' What is the option to control that ?

Don't forget joins like "inner join" or "left join"

Is it possible to use pl/sql developper to format pl/sql code from the command line ? I don't want to buy a license of Quest Formatter Plus.

There is already a special copy to java. It can be enhanced: remove the extra blank spaces and the \n. It is better to have a smaller string in java. (Maybe in 2 steps with a UnBeautifier that trims all the extra spaces) I'd like also a paste from java. For example: "select t.* from emp t "...

I'd like to beautify packages, triggers, procedures and functions in a batch process. I have an application that generates triggers. When I get an error line number, the beautifier in pl/sql dev changes the lines and the lines don't match anymore. I know I can deactivate the beautifier. I'd...

I have tables with sys.xmltype colums. When I do a "query data" on this table, I get a very long sql statement on one line. I'd like this statement to be auto-beautified. Regards, Jean-Paul Finne

Enhancement requests for "copy to Excel" 1) add the sql statement into a cell (with formatting like "wrap text", "Merge cells", "vertical:Top") 2) add the title of the sql window. Jean-Paul

By the way, sqlplus displays XMLTYPES() with the same sql statement.

Please handle sys.xmltype the same way in the sql window as in the command window. I don't like results with columns that are "magically" removed or modified.

select * from table1 in a sql Window doesn't display the INFO column. I'd rather see the INFO column as . It is very confusing that some columns are invisible.