ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Shift+F4 opens up a useful popup containing object information. However, unfortunately, in some cases the object information is displayed for the wrong object, especially when qualifying objects. Consider the following two SQL statements:
COMMENT ON COLUMN sakila.film.film_id IS 'abc';
(Assuming of course a SAKILA schema/user and a FILM table with a FILM_ID column)
Now, place the cursor on any of the 3 film table identifiers. In the COMMENT statement and in the SELECT clause, the popup will contain information for the SAKILA user instead of the FILM table. In the FROM clause, the behaviour is correct.
When placing the cursor on any of the 3 schema identifiers, the inverse is the case and the user information is displayed in COMMENT and SELECT, but not in FROM.
This is inconsistent. I would expect any of these two fixes:
When placing the cursor on qualified identifiers, Shift F4 will display the object info of the specific object under the cursor. So, when placed on schema.table.column's schema, the schema/user info is displayed. When placed on the table, the table info is displayed. When placed on the column, the column info is displayed
Qualification doesn't matter, the popup always displays the object information of the last identifier part. So, COMMENT and SELECT would display column information. FROM would display table information.