2

I will do a presentation where I will present some complex sql queries. The audience has no idea about my project, so I cannot just explain by showing the query. I need a tool (diagram?) that allows me to explain my query. Using class diagran or ER diagram is not enough because I want to represent every thing in my query like joins, loops, cursors...

Thank you for your help.

Batman K
  • 71
  • 5
  • Your question is not about programming, and therefore it does not belong on Stack Overflow. It's a legitimate question, no doubt - you are just asking it in the wrong place. If the question gets closed again and you ask it a third time, I will flag it as a violation. –  Feb 06 '21 at 16:18
  • I think we can talk about uml and diagrams here. It is not only reserved for programming. Database is not programming and we can talk about it – Batman K Feb 06 '21 at 16:25
  • The other topic doesn't answer my question – Batman K Feb 06 '21 at 16:26
  • "Database is not programming" is wrong. We access the database through queries (primarily SQL), and we manipulate the data with various programming languages, including ones developed specifically for the database, such as PL/SQL (in addition to general purpose languages like Java and C#). This site is for programming questions, and the `sql` and `oracle` (etc.) tags are for programming in SQL, while the `plsql` tag is for PL/SQL programming questions. You tagged your post with `uml`, for example - but you don't have a specific UML question, do you? –  Feb 06 '21 at 19:06
  • query can be presented as execution plan, drive tables and sequence of access tables/views, and how they are joined, is that what you look for? – scott yu Feb 08 '21 at 16:54
  • @scottyu Yes how can present all of that clearly, so people can understand my work? – Batman K Feb 08 '21 at 18:03
  • because stackoverflow is mostly words based, I try to explained as word of sql programer/dba, – scott yu Feb 09 '21 at 12:25
  • in oracle sqlplus you can set autotrace on, you can generate explain plan, that will tell you driving tables access path(like fiter, or join keys) – scott yu Feb 09 '21 at 12:37

0 Answers0