Columns pick list not showing in SQL developer with table alias

user527460 · Jun 3, 2022 5:56PM

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.

User_GS75N · Jun 7, 2022 8:10AM

I think you wanted DESC, not DEPT.

DESC tablename;

thatJeffSmith-Oracle · Jun 7, 2022 12:26PM

Pictures are worth many words, show us

user527460 · Jun 7, 2022 2:32PM

Here is the picture from SQL Developer version 21.4.3.x,

Picklist is not showing with table alias 'a' as shown here.

thatJeffSmith-Oracle · Jun 7, 2022 4:58PM

That query to get the column list might take a half-second, be patient

Windows 10/21.4.3

user527460 · Jun 7, 2022 6:31PM

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.

thatJeffSmith-Oracle · Jun 7, 2022 6:33PM

ask for it multiple times, if the query takes too long, we give up

Forum Stats