Incorporate autocompletion within the editor when working with the body of a procedure, function, view and other objects where we currently don't allow autocompletion

see Kin-Hong's note below:

autocomplete was initially only designed for select statements. We do offer limited (much reduced) autocomplete support for CREATE [VIEW|TABLE|COLLECTOIN|INDEX], but not at all for CREATE [PROC|FUNCTION] and others.