Hi, is it possible to enhance Code Assistant - in case you have named select, for example named 'q':
place cursor after the 'q.' and hit F6, Code Assistant will occur and it lists all columns in the 'q' select
Is it possible to add to first place the '(all)' selection, which will add all columns from named select?
SQL:
select q. from
(
select '1' as col, '2' as col2, '3' as col3 from dual
union
select '2' as col, '2' as col2, '3' as col3 from dual
union
select '3' as col, '2' as col2, '3' as col3 from dual
) q;
place cursor after the 'q.' and hit F6, Code Assistant will occur and it lists all columns in the 'q' select
Is it possible to add to first place the '(all)' selection, which will add all columns from named select?