Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
When I want to create an select like the following
SELECT departments_seq.NEXTVAL FROM dual
there is no support for auto completion of dep to departments_seq or of . to .NEXTVAL.
you can DnD the sequence from the tree, but you're right there's no completion on the sequence name itself.
However, if i type
select sequence. from dual and invoke insight, I get offered to add currval, and nextval. When I select THAT, the sequence name is removed. I'll log a bug on that.