Hi there,
just installed new version of SQL Developer ( 22.2.1.234 ) , on a first try everything seemed fine, but found that autocomplete when partialy typing function and procedure names ( followed by ctrl+space ) not working as expected ( at least for me ). Packages autocomplete not working too, only when i type the whole name with dot after, then it lists subroutines.
Posted a question on @thatjeffsmith-oracle kindly suggested to post question here
Install procedure was just simple download and unzip of windows zip with JDK included, tried it on PC and laptop, win10 and win11
This is how it worked on 20.2 version after pressing ctrl+space
Also peeked on "Statements" tab to look what if fires against database, in version 20.2 it executes query "
SELECT object_type type, owner owner, object_name, null column_name, null column_id, null data_type
FROM all_objects
WHERE rownum <=50 and object_name not like 'BIN$%' and object_type IN ('PROCEDURE','FUNCTION','PACKAGE','OPERATOR')
and object_name like ?
union all
SELECT 'SEQUENCE' type, USER owner, object_name, 'NEXTVAL' column_name, null column_id, null data_type
FROM sys.user_objects
WHERE object_type = 'SEQUENCE' and rownum <=50 and object_name like ?
"
, but on version it fires nothing
Thx