Explore Oracle with VISKey

  • Explore the data dictionary.
  • Create queries against the dictionary.
  • Get sample statements (DDL,SQL) for all objects.
  • Fast access to Oracle documenation.

How does it work ?

  • Step-1: Select a topic from the left side, like "Tables".

  • Step-2: Select "Commands" from the top, if you want to see sample DDL/SQL.
  • Basic commands like
    CREATE, ALTER, SELECT, MERGE,... are shown.
  • By pressing the book icon,
    the correpsonding Oracle documenation will be opened.

  • Step-3: Select "Data Dictionary: DBA/ALL" to view dictionary views.
  • Just click on a single table
    or create complex joins.
  • "Left Joins" are created between
    the driving table and the linked tables.
  • If you have select just 1 table,
    you will get a simple table select.

  • Step-4: Get a simple table select.
  • If you select multiple tables,
    you will get select statement, including joins.

  • Step-5: Get a joined select statement.

 Some words about VISKey

The motivation for creating this page, was the wish to have a simple lookup tool, to get the select statements for the most popular data dictionary views.

Sometimes these views got dozens of columns and i got lost by picking the most useful information.
Therefore, i decided to also display sample data, based on sample commands.

These sample commands are just "mainstream" commands to illustrate the basic usage of an object like a "Sequence".
The page will not show you the full power and functionality of a command !

The relations between the data dictionary views are based on my experience as an Oracle developer.
Just drop me a mail, if you see a mistake or issue.

My biggest challenge was to find an adequate name for this page.

I decided for VISKey, because the 2 main ingredients are:

VIS is a dynamic, browser based visualization library, written in JavaScript.
Key: like unique or foreign keys that are necessary to create a relational data model.

For the implementation of this page, i was happy to have a lookup at:

  • Oracle Data Dictionary from RenĂ© Nyffenegger
  • Index Usage Tracking from Franck Pachot

  • Feel free to write any comment, hint or wish to: J. Rapp or contact me on LinkedIn.