Code Assistant and DB Links enhancement in 8.0.4

[William Robertson]

I was pleased to see in the 8.0.4 enhancements list that "Code Assistant can now complete database link names". However I was hoping it could start when I entered an "@" symbol, e.g.

select * from dual@ <- press 'Code Assistant' hotkey here

This just gives the standard error about how CA can only be invoked after a period, comma or left parenthesis or at the end of a word.

Then when I do enter some characters, the list contains all matching object names, not just db links. You would think that the '@' symbol would give it a clue that I am not looking for table names here.

Then when the db link is specified, it still can't look up attributes from the remote object, e.g.

select d. <- press 'Code Assistant' hotkey here
from   dual@remotesite d

This is a bit of a nice-to-have feature, but I wouldn't think it would be too hard to implement. Especially as I first suggested it in 2006
Enhancement suggestion - autocompletion of DB links

 

[Marco Kalter]

The database links are in the code assistant list though. It is just not interpreting the @ sign. We'll add this feature.