Toad World® Forums

Problem with ANSI-Join converter


#1

Hi

In Toad for Oracle 12.10.0.30 (I don’t know in 13.x since I can’t find any Licence).

Say a query :

SELECT * FROM t1, t2 WHERE t1.f1=t2.f1;

It will be converted to :

SELECT * FROM myschema.t1 LEFT OUTER JOIN myschema.t2 f ON (t1.f1=t2.f1);

The problem is that there is no reason to add the schema name (myschema). It our environment it produces bugs if we don’t remove them.

Could this be changed in next versions if it is not already done ?

Thanks