Hi,
my Toad does not show the Pick-List if I use the ANSI JOIN Syntax.
The only way that it’s working is, if I start with the complete table name. but in this case ORACLE says invalid SQL.
If I use Oracle SQL Syntax, the Pick-List is working as expected.
Example:
select * from emp e, dept d
where E.DEPTNO = D.DEPTNO;
select * from emp e
join DEPT d ON(e.
select * from emp e
join DEPT d ON(EMP.DEPTNO = DEPT.DEPTNO);
-
–> Pick List is working fine
-
–> No Pick List available(The circle pops up for some miliseconds, but nothing else happens)
-
–> Pick List is working fine, but Oracle gives an error.
Is this a known Bug and is there a workaround?
Thank you!