Hello
I'm using SQL developer at work on a big database for which I don't know all the tables. The Completion Insight is really useful to help me query my tables.
I enabled Completion Insight, ticked all the boxes, increased time to search to 1,7s and I look up for more than 1000 matches.
When I write my queries such as : "SELECT * FROM" and then hit ctrl-space or wait for the completion insight pop up to appear, it allows me to select from the tables I have.
Nevertheless, when I write things like "SELECT * FROM table WHERE table." and use completion it gives me results such as : "CREATE_PROCEDURE, json....." and not the suggestions on the columns the table is using.
Does anyone know how can I fix the problem ?
(Sorry for not using screenshots, for confidentiality reasons on the databases I stick to text)
Thankyou for your time
Paul