Data Dictionary columns

Toad for Oracle
1

How come when I pause after typing the name of a Data Dictionary view, I
don’t get the column pick list like I do for tables? I work a lot with DD
views so it sure would help me if it did.

Dan Clamage

Oracle Database Developer

C O N F L U E N C E

412.246.1806 direct

412.802.8632 main

412.802.8647 fax

THE MATERIAL CONTAINED IN THIS MESSAGE IS CONFIDENTIAL AND IS SUBJECT TO
RESTRICTIONS ON ITS DISCLOSURE. The recipient acknowledges that the information
contained herein is the exclusive, proprietary and confidential property of
Confluence Technologies, Inc. and shall be at all times regarded, treated and
protected as such by the recipient. The use and disclosure of this information
is subject to the restrictions contained in the Software License Agreement
between the recipient (or the recipient’s employer or its affiliates) and
Confluence Technologies, Inc.

2

B/c they are Public Synonyms – like ALL_TABLES

ALL_TABLES is actually – SYS.ALL_TABLES.

You can get it to work. In your code insight options, enable support for Public
Syns. It’s disabled by default for performance reasons.
image001.png