12.9.0.13 Picklist not working in JOIN conditions

The new picklist looks promising, could you please have a look at this issue?

SELECT *
FROM user_tables tab
JOIN user_tab_cols cl ON ( cl.| – No picklist here

Same here:

SELECT *
FROM user_tables tab, user_tab_cols cl
WHERE cl.| – No picklist here

Your first issue is a bug, the second works for me. Make sure that you have Join suggestions checked in the Code Insight options. If you do have it checked look at the Code Insight window and notice if the Cancel button is enabled. If it is let it finish executing and see if the results display.

Michael

On 01/08/2016 03:21 AM, Peter Lang wrote:

12.9.0.13 Picklist not working in JOIN conditions

Thread created by Peter Lang
The new picklist looks promising, could you please have a look at this issue?

SELECT *

FROM user_tables tab

JOIN user_tab_cols cl ON ( cl.| -- No picklist here

Same here:

SELECT *

FROM user_tables tab, user_tab_cols cl

WHERE cl.| -- No picklist here

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.