Forum Stats

  • 3,874,339 Users
  • 2,266,726 Discussions


Autocomplete data dictionary views

Jack Trocinski
Jack Trocinski Member Posts: 4
edited May 13, 2018 10:37PM in SQLcl

I can't seem to autocomplete column names using tab in the SELECT clause when in the FROM clause of my statement I have a data dictionary view such as user_errors, am I doing something wrong?  Tab auto completion spits out odd name suggestions like TO_DATE or NULL.

*         .         :         COUNT     NULL      SUM       TO_DATE   [email protected] 04:54:05> select  2  from user_error;
Jack Trocinski

Best Answer

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited Aug 21, 2017 11:10PM Answer ✓

    Get the spelling of the view right and prefix the view with the owner name, in this case, SYS:

    ATTRIBUTE        LINE             MESSAGE_NUMBER   NAME             POSITION         SEQUENCETEXT             TYPE SQL> SELECT   2  FROM   sys.user_errors;
    Jack TrocinskiJack Trocinski