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.