Code Assistant...

[CTucker]

Code Assistant does not recognize Materialized View columns.

For example,

SELECT *
FROM m_view_1 t
WHERE t. -- Code assistant will not give any columns to pick from.

 

[ScottMattes]

It also doesn't recognize the fields of a record (granted, the record is defined in another package).

 

[BWendling]

Code Assistant should recognize column names for single tables even without alias.

SELECT * FROM dual
WHERE -- Code Assistant should display column(s) of table dual.

 

[Marco Kalter]

We'll fix the materialized view and record type issues. I have added the "Code Assistant without alias" option to the list of enhancement requests.