Toad World® Forums

ANSI-Join converter does not work in editor?

In my Toad 12.1 I just found ANSI-Join converter in editors context-Menu:
refactor -> convert to ANSI join syntax
refactor -> convert to Oracle join syntax
But this does nothing.
Toad Help does mention the Join converter only for automation designer and query builder.
Is this a bug or a “prepared future feature”?
bye
Thomas

What is your statement? It works with a sample statement I just threw at it although the statement was quite simple to begin with.

On 05/21/2014 12:15 PM, ThomasP wrote:

ANSI-Join converter does not work in editor?

Thread created by ThomasP
In my Toad 12.1 I just found ANSI-Join converter in editors context-Menu: refactor -> convert to ANSI join syntax refactor -> convert to Oracle join syntax But this does nothing. Toad Help does mention the Join converter only for automation designer and
query builder. Is this a bug or a “prepared future feature”? bye Thomas

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

There are times when people’s editor content is read only - i…e. file is read only or the object in the editor is included in team coding code set - so then the refactor does nothing and does not display any message. I have put this issue on the roadmap. It could very well be this that you are experiencing …

I pasted tis in a new editor tab:

SELECT /*+ ORDERED USE_NL(copa cofi) */

        copa.copa_id

       , cofi.cofi_id

    FROM pac_zuo_cofi_pave copa

       , pac_code_file cofi

   WHERE copa.cofi_id = cofi.cofi_id

     AND copa.pave_id = p_pave_id

     AND cofi.file_name = p_file_name

     AND cofi.file_extension = p_file_extension

     AND cofi.revision = p_revision

     AND NVL( cofi.codegen_mode, 2 ) = 2

    AND cofi.code_format = p_code_format

     AND cofi.comp_id = p_comp_id;

and it was not converted to ANSI-Joins.

does look simle enough to me…

bye

Thomas

OK, removing the hint comment does the trick…

bye

Thomas