Toad World® Forums

Pick-List in 12.8.0.49 not working for ANSI Join Syntax

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);

  1. –> Pick List is working fine

  2. –> No Pick List available(The circle pops up for some miliseconds, but nothing else happens)

  3. –> Pick List is working fine, but Oracle gives an error.

Is this a known Bug and is there a workaround?

Thank you!

#2 is fixed for 12.9, currently OK in beta.

#3 is a bug in your SQL. You need to use the table alias.

Michael