Correspondendo a: recursion X
Recursive SQL using Common Table Expression Blog da Comunidade
Luiz da Silva Marcações: recursive-sql sql common-table-expression recursion cte 614 Visualizações
Have you ever needed to convert rows into columns? Which approach have you used for that? In general words, you would need to have a programming logic to scan the rows involved and getting values and preparing the final value. But you can do that using...
do Blog: DB2 ideasModificado em por Luiz da Silva
SergeRielau Marcações: function procedure sql routine sql_pl fibonacci recursion 7 Comentários 22.095 Visualizações
Motivation There are multiple ways in which DB2 supports recursion in SQL. One of which is recursion using the ANSI SQL recursive UNION ALL approach. The other approach is using the CONNECT BY clause. Actually I like to add explanation of recursion into my...
do Blog: SQL Tips for DB2 LUW
MatthiasNicola Marcações: pathtable sql xml document recursive paths xquery recursion 2.755 Visualizações
A common question is how to obtain a list of all the elements and attributes that occur in an XML document. Producing such a list is what I call “XML profiling” and in a previous blog post I have discussed several SQL/XML queries that can do this. An...
do Blog: The XML Database Blog