Banco de DadosOracle

The Adventures of Ace, DBA

No Comments

  • Alexandru Toth disse:


    (Sorry for the spam)

    You might be interested in using the “snowflake query” diagrams generated with the “Reverse Snowflake Joins” open source tool. You can find a presentation at

    The tool parses SQL Select statements and generates a diagram. It shows parts of the underlying SQL directly in the diagram. For example x=30 , GROUP BY (year), SUM(sales), HAVING MIN(age) > 18.

    The primary reason for the tool was to avoid cartesian joins and loops in SQL written by hand, with many joined tables. The database will execute such a syntactically correct statement , even though it is not what the user intended to get.


Leave a Reply

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.