Toad World® Forums

Code Assist: Not working for columns when another column comes afterwards

Code completion does not work in the following case. It does work before I type the “a” (tab.| works).

SELECT tab.owner,
tab.a|
tab.table_name
FROM all_tables tab;

Can you reproduce this?

I can reproduce and this is yet another permutation of the incomplete statement limitation. Once the “a” is introduced the parser does not report on table references so Code Insight doesn’t know what to show you. The issue has been logged extensively, but there is no ETA yet.