Columns pick list not showing in SQL developer with table alias

user527460

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

I think you wanted DESC, not DEPT.

DESC tablename;

thatJeffSmith-Oracle

Pictures are worth many words, show us

user527460

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.

thatJeffSmith-Oracle

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

Windows 10/21.4.3

user527460

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.

thatJeffSmith-Oracle

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