Completion Insight function for partial typed column is still not resolved in version 23.1.1.345. For example, when typed below query:
select * from fnd_lookup_types flt
where flt.loo
column list starting with loo doesn't show up, from Log / Statements page, we can see there is a bug with the backend query:
select column_name from all_tab_columns where owner = :1 and table_name = :2
and column_name like :2 and rownum < 50 order by column_name,
Input parameters are 1="APPLSYS", 2="FND_LOOKUP_TYPES#", 3="%LOO%".
Problems are: 1.) column_name condition should be against 3rd parameter; 2.) value of 3rd parameter shall be LOO%, without % prefix
This is on Windows platform. This issue has been there since 21.2.1.204, sadly it's still not resolved, and causing that all later releases cannot be used for daily development.