Recent content by Dennis Schafthuizen

Can you put it on the list of enhancement requests? Above is just a simple example and then it's not a big deal, but when you use the quote operator in PL/SQL then the code could be unreadable.

It works using the 10g ORACLE_HOME, but syntax highlighting in the SQL Window doesn't work in the following case: select q'!John's shop!' from dual; The following (in bold) is highlighted as comment: select q'!John's shop!' from dual; instead of: select q'!John's shop!' from dual;

You can use CTRL+H to toggle between the editor and dialog tab in the Command Window. It also works in the Program Window to toggle between a package specification and a package body.

Yes, that's the case. Using the 10g Oracle home solved the problem. Thanks.

In 10g it's possible to use the quote operator q. For example: select q'!John's shop!' title from dual; In SQL*Plus the result is: TITLE ----------- John's shop In PL/SQL Developer 7.0.2.1076 (SQL Window and Command Window) the following error occurs: ORA-01756: quoted string not properly...

MArco, I'm using version 7.0.1.1060. I also had these problems with the previous version.

When I select data from an object view in the SQL Window sometimes the SQL Window "hangs". When I want to close the Window I get the message that the query is still executing. I only have this with queries on object views which are more than 2 levels deep. An other problem is the result of an...

In the SQL and Test Window it's possible to use several options (e.g. name, hint, default) for variables. In the Command Window the following statement returns an ORA-00922 error: alter session set optimizer_mode = & ORA-00922: missing or invalid option Is it possible to use the options for...

That's correct. If it's not implemented by search in a filter of a folder but by entering a separate where-clause it would be nice to save the where-clause.

The code assistant in the Program Window works fine if the "("is right behind the name of a function. If you type "(" on the next line, the Code assistant doesn't work. Is it possible to add this to the list of enhancement requests? Thanks in advance.

In our project (for example 1600 packages, 1300 tables, 6000 triggers) where everything is installed under 1 owner it takes a long time before the search is finished. Most of the times you want to search in a specific part which can be identified by a browser filter or by an user defined folder...

Is it possible to activate the history and the list of fixed users at the logon screen without using the mouse and only use the keyboard?

In version 5 the Find DB objects searched within the selected browser filter. Is this feature gone? For a large application is was very useful that the search took place within the selected filter. Can this be re-introduced? Maybe as option so you can choose withtin the filter or not. An other...

In the following situation the hihglight for if,loop and case keywords does not work: create or replace procedure des_test is l_dummy varchar2(1); begin l_dummy := case when 1=1 then 'Y' else 'N' end ; end;