For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Columns pick list not showing in SQL developer with table alias. e.g. DEPT a a. is not showing column list to pick while writing query.
I think you wanted DESC, not DEPT. DESC tablename;
Pictures are worth many words, show us
Hi, @thatjeffsmith-oracle , Here is the picture from SQL Developer version 21.4.3.x, Picklist is not showing with table alias 'a' as shown here.
That query to get the column list might take a half-second, be patient Windows 10/21.4.3
hi @thatjeffsmith-oracle , No luck, i waited for a min but pick list not showing. I tried to change theme to dark as showing in your image, still no pick list pops up.
ask for it multiple times, if the query takes too long, we give up
Try Ctrl-Space.
Ctrl-Space is not working in Version 22.2.1.234
it brings up a different menu.
23.1.1 is latest and this is your example in 23.1.1