<\/td>\n<\/tr>\n\n| 78<\/td>\n | 9.7.4 Nested table function invocation
9.8 Table argument correlation name
9.9 Table argument column renaming <\/td>\n<\/tr>\n |
\n| 79<\/td>\n | 9.10 Range variables and column renaming in nested PTF
9.11 Partitioning <\/td>\n<\/tr>\n |
\n| 80<\/td>\n | 9.12 Pruning
9.13 Ordering <\/td>\n<\/tr>\n |
\n| 81<\/td>\n | 9.14 Co-partitioning <\/td>\n<\/tr>\n |
\n| 82<\/td>\n | 9.15 Cross products of partitions
9.16 <\/td>\n<\/tr>\n |
\n| 83<\/td>\n | 10 Compilation
10.1 Introduction to PTF compilation
10.2 Calling the describe component procedure
10.3 Inside the describe component procedure <\/td>\n<\/tr>\n |
\n| 84<\/td>\n | 10.4 Using the result of describe <\/td>\n<\/tr>\n |
\n| 85<\/td>\n | 11 Optimization <\/td>\n<\/tr>\n |
\n| 86<\/td>\n | 12 Execution
12.1 Introduction to PTF execution
12.2 Partitions and virtual processors <\/td>\n<\/tr>\n |
\n| 87<\/td>\n | 12.3 Calling the start component procedure
12.4 Inside the start component procedure <\/td>\n<\/tr>\n |
\n| 88<\/td>\n | 12.5 Calling the PTF fulfill component procedure
12.6 Inside the PTF fulfill component procedure
12.7 Closing cursors
12.8 Calling the PTF finish component procedure <\/td>\n<\/tr>\n |
\n| 89<\/td>\n | 12.9 Inside the PTF finish component procedure
12.10 Collecting the output
12.11 Cleanup on a virtual processor
12.12 Final result <\/td>\n<\/tr>\n |
\n| 90<\/td>\n | 13 Examples
13.1 Introduction to the examples <\/td>\n<\/tr>\n |
\n| 91<\/td>\n | 13.2 Projection
13.2.1 Overview
13.2.2 Functional specification of Projection <\/td>\n<\/tr>\n |
\n| 92<\/td>\n | 13.2.3 Design specification for Projection
13.2.4 Projection component procedures <\/td>\n<\/tr>\n |
\n| 94<\/td>\n | 13.2.5 Invoking Projection
13.2.6 Calling Projection_describe <\/td>\n<\/tr>\n |
\n| 96<\/td>\n | 13.2.7 Inside Projection_describe <\/td>\n<\/tr>\n |
\n| 98<\/td>\n | 13.2.8 Result of Projection_describe
13.2.9 Virtual processors for Projection <\/td>\n<\/tr>\n |
\n| 99<\/td>\n | 13.2.10 Calling Projection_fulfill <\/td>\n<\/tr>\n |
\n| 100<\/td>\n | 13.2.11 Inside Projection_fulfill
13.2.12 Collecting the results <\/td>\n<\/tr>\n |
\n| 101<\/td>\n | 13.2.13 Cleanup <\/td>\n<\/tr>\n |
\n| 102<\/td>\n | 13.3 CSVreader
13.3.1 Overview
13.3.2 Functional specification of CSVreader
13.3.3 Design specification for CSVreader <\/td>\n<\/tr>\n |
\n| 103<\/td>\n | 13.3.4 CSVreader component procedures <\/td>\n<\/tr>\n |
\n| 104<\/td>\n | 13.3.5 Implementation of CSVreader
13.3.6 Invoking CSVreader <\/td>\n<\/tr>\n |
\n| 105<\/td>\n | 13.3.7 Calling CSVreader_describe <\/td>\n<\/tr>\n |
\n| 107<\/td>\n | 13.3.8 Inside CSVreader_describe <\/td>\n<\/tr>\n |
\n| 108<\/td>\n | 13.3.9 Result of CSVreader_describe <\/td>\n<\/tr>\n |
\n| 110<\/td>\n | 13.3.10 Virtual processor for CSVreader
13.3.11 Calling CSVreader_start <\/td>\n<\/tr>\n |
\n| 111<\/td>\n | 13.3.12 Inside CSVreader_start
13.3.13 Calling CSVreader_fulfill
13.3.14 Inside CSVreader_fulfill <\/td>\n<\/tr>\n |
\n| 112<\/td>\n | 13.3.15 Collecting the output
13.3.16 Calling CSVreader_finish
13.3.17 Inside CSVreader_finish <\/td>\n<\/tr>\n |
\n| 113<\/td>\n | 13.3.18 Cleanup <\/td>\n<\/tr>\n |
\n| 114<\/td>\n | 13.4 Pivot
13.4.1 Overview
13.4.2 Functional specification of Pivot
13.4.3 Design specification for Pivot <\/td>\n<\/tr>\n |
\n| 115<\/td>\n | 13.4.4 Pivot component procedures <\/td>\n<\/tr>\n |
\n| 116<\/td>\n | 13.4.5 Invoking Pivot
13.4.6 Calling Pivot_describe <\/td>\n<\/tr>\n |
\n| 120<\/td>\n | 13.4.7 Inside Pivot_describe <\/td>\n<\/tr>\n |
\n| 121<\/td>\n | 13.4.8 Result of Pivot_describe <\/td>\n<\/tr>\n |
\n| 123<\/td>\n | 13.4.9 Virtual processors for Pivot <\/td>\n<\/tr>\n |
\n| 124<\/td>\n | 13.4.10 Calling Pivot_fulfill
13.4.11 Inside Pivot_fulfill <\/td>\n<\/tr>\n |
\n| 125<\/td>\n | 13.4.12 Collecting the results
13.4.13 Cleanup <\/td>\n<\/tr>\n |
\n| 126<\/td>\n | 13.5 Score
13.5.1 Overview
13.5.2 Functional specification of Score
13.5.3 Design specification for Score <\/td>\n<\/tr>\n |
\n| 127<\/td>\n | 13.5.4 Score component procedures <\/td>\n<\/tr>\n |
\n| 128<\/td>\n | 13.5.5 Invoking Score
13.5.6 Calling Score_describe <\/td>\n<\/tr>\n |
\n| 131<\/td>\n | 13.5.7 Inside Score_describe <\/td>\n<\/tr>\n |
\n| 132<\/td>\n | 13.5.8 Result of Score_describe <\/td>\n<\/tr>\n |
\n| 133<\/td>\n | 13.5.9 Virtual processors for Score <\/td>\n<\/tr>\n |
\n| 135<\/td>\n | 13.5.10 Calling Score_fulfill
13.5.11 Inside Score_fulfill <\/td>\n<\/tr>\n |
\n| 136<\/td>\n | 13.5.12 Collecting the output <\/td>\n<\/tr>\n |
\n| 137<\/td>\n | 13.5.13 Cleanup <\/td>\n<\/tr>\n |
\n| 138<\/td>\n | 13.6 TopNplus
13.6.1 Overview
13.6.2 Functional specification of TopNplus
13.6.3 Design specification for TopNplus <\/td>\n<\/tr>\n |
\n| 139<\/td>\n | 13.6.4 TopNplus component procedures <\/td>\n<\/tr>\n |
\n| 140<\/td>\n | 13.6.5 Invoking TopNplus
13.6.6 Calling TopNplus_describe <\/td>\n<\/tr>\n |
\n| 143<\/td>\n | 13.6.7 Inside TopNplus_describe <\/td>\n<\/tr>\n |
\n| 145<\/td>\n | 13.6.8 Result of TopNplus_describe
13.6.9 Virtual processors for TopNplus <\/td>\n<\/tr>\n |
\n| 147<\/td>\n | 13.6.10 Calling TopNplus_fulfill
13.6.11 Inside TopNplus_fulfill <\/td>\n<\/tr>\n |
\n| 148<\/td>\n | 13.6.12 Collecting the output
13.6.13 Cleanup
13.6.14 TopNplus using pass-through columns <\/td>\n<\/tr>\n |
\n| 151<\/td>\n | 13.7 ExecR
13.7.1 Overview
13.7.2 Functional specification of ExecR
13.7.3 Design specification for ExecR <\/td>\n<\/tr>\n |
\n| 152<\/td>\n | 13.7.4 ExecR component procedures <\/td>\n<\/tr>\n |
\n| 153<\/td>\n | 13.7.5 Invoking ExecR
13.7.6 Calling ExecR_describe <\/td>\n<\/tr>\n |
\n| 155<\/td>\n | 13.7.7 Inside ExecR_describe <\/td>\n<\/tr>\n |
\n| 156<\/td>\n | 13.7.8 Result of ExecR_describe
13.7.9 Virtual processors for ExecR <\/td>\n<\/tr>\n |
\n| 157<\/td>\n | 13.7.10 Calling ExecR_start
13.7.11 Inside ExecR_start <\/td>\n<\/tr>\n |
\n| 158<\/td>\n | 13.7.12 Calling ExecR_fulfill
13.7.13 Inside ExecR_fulfill
13.7.14 Collecting the output <\/td>\n<\/tr>\n |
\n| 159<\/td>\n | 13.7.15 Calling ExecR_finish
13.7.16 Inside ExecR_finish
13.7.17 Cleanup <\/td>\n<\/tr>\n |
\n| 160<\/td>\n | 13.8 Similarity
13.8.1 Overview
13.8.2 Functional specification of Similarity
13.8.3 Design specification for Similarity <\/td>\n<\/tr>\n |
\n| 161<\/td>\n | 13.8.4 Similarity component procedures
13.8.5 Invoking Similarity <\/td>\n<\/tr>\n |
\n| 162<\/td>\n | 13.8.6 Calling Similarity_describe <\/td>\n<\/tr>\n |
\n| 164<\/td>\n | 13.8.7 Inside Similarity_describe <\/td>\n<\/tr>\n |
\n| 165<\/td>\n | 13.8.8 Result of Similarity_describe
13.8.9 Virtual processors for Similarity <\/td>\n<\/tr>\n |
\n| 169<\/td>\n | 13.8.10 Calling Similarity_fulfill
13.8.11 Inside Similarity_fulfill <\/td>\n<\/tr>\n |
\n| 170<\/td>\n | 13.8.12 Collecting the output
13.8.13 Cleanup <\/td>\n<\/tr>\n |
\n| 171<\/td>\n | 13.9 UDjoin
13.9.1 Overview
13.9.2 Functional specification of UDjoin
13.9.3 Design specification for UDjoin <\/td>\n<\/tr>\n |
\n| 172<\/td>\n | 13.9.4 UDjoin component procedures
13.9.5 Invoking UDjoin <\/td>\n<\/tr>\n |
\n| 173<\/td>\n | 13.9.6 Calling UDjoin_describe
13.9.7 Inside UDjoin_describe <\/td>\n<\/tr>\n |
\n| 174<\/td>\n | 13.9.8 Result of UDjoin_describe
13.9.9 Virtual processors for UDjoin
13.9.10 Calling UDjoin_fulfill <\/td>\n<\/tr>\n |
\n| 175<\/td>\n | 13.9.11 Inside UDjoin_fulfill
13.9.12 Collecting the output
13.9.13 Cleanup <\/td>\n<\/tr>\n |
\n| 176<\/td>\n | 13.10 Nested PTF invocation
13.10.1 Introduction to nested PTF invocation
13.10.2 Nested PTF syntax and semantics <\/td>\n<\/tr>\n |
\n| 178<\/td>\n | 13.10.3 Nested PTF compilation <\/td>\n<\/tr>\n |
\n| 180<\/td>\n | 13.10.4 Nested PTF execution <\/td>\n<\/tr>\n |
\n| 181<\/td>\n | 13.10.5 The PTF author\u2019s view of nested PTF invocations <\/td>\n<\/tr>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Information technology. Guidance for the use of database language SQL – Polymorphic table functions<\/b><\/p>\n\n\n\n| Published By<\/td>\n | Publication Date<\/td>\n | Number of Pages<\/td>\n<\/tr>\n | \n| BSI<\/b><\/a><\/td>\n | 2021<\/td>\n | 188<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"featured_media":423058,"template":"","meta":{"rank_math_lock_modified_date":false,"ep_exclude_from_search":false},"product_cat":[2641],"product_tag":[],"class_list":{"0":"post-423050","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-bsi","8":"first","9":"instock","10":"sold-individually","11":"shipping-taxable","12":"purchasable","13":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product\/423050","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media\/423058"}],"wp:attachment":[{"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/media?parent=423050"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_cat?post=423050"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pdfstandards.shop\/wp-json\/wp\/v2\/product_tag?post=423050"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | |