[MihaiCazac]

Code completion works fine if I invoke the table name , then ‘.’ and hit ‘Ctrl+Spc’.
I should like to have code completion working after I use the table alias , like
in the following example:

select a.<Ctrl+Spc> ,
       b.<Ctrl+Spc>
  from TABLE_A a,
       TABLE_B b
 where
       a.<Ctrl+Spc> = b.<Ctrl+spc>;

I understand that it would be impossible to have column name code completion working
in the first two situations (immediately after writing ‘select a.’ ) because in that moment
the tables name are unknown yet, but I think it is preferable to write first something like :

select 
  from TABLE_A a,
       TABLE_B b
 where
 ;

, in order to specify the tables and their aliases , and after that to go back on some lines
of the SQL and type a.<Ctrl+Spc> to take benefit on the column name code completion.

[Riyad Kalla]

This is an open enhancement request, I have added your vote to it.

[Author]

Posts