Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Autocomplete data dictionary views

Jack TrocinskiAug 21 2017 — edited May 13 2018

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  

HR@ORCL 04:54:05> select

  2  from user_error;

This post has been answered by Gaz in Oz on Aug 21 2017
Jump to Answer

Comments

Processing

Post Details

Added on Aug 21 2017
3 comments
279 views