---
title: "Discussion on \"Turn Complex Logic into Simple SQL using Pipelined Table Functions\" | Hashnode"
description: "Discussion on \"Turn Complex Logic into Simple SQL using Pipelined Table Functions\". Oracle Pipelined Table Functions allow APEX devs to turn complex calculations, conditional logic, and REST service calls into simple SQL statements."
url: "https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Turn Complex Logic into Simple SQL using Pipelined Table Functions](https://blog.cloudnueva.com/apex-and-pipelined-table-functions?utm_source=hashnode&utm_medium=feed)

Oracle Pipelined Table Functions allow APEX devs to turn complex calculations, conditional logic, and REST service calls into simple SQL statements.

Jun 1, 2023 · 5 min read · blog.cloudnueva.com  
Updated Jun 2, 2023  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#plsql](https://hashnode.com/tag/plsql)
-   [#sql](https://hashnode.com/tag/sql)

## Written by

[Jon Dixon](https://hashnode.com/@orclapex)

@orclapex · San Diego, CA

  
[View profile](https://hashnode.com/@orclapex)

APEX, ORDS & the Oracle Database

I’m Jon Dixon, an Oracle APEX developer and consultant at Cloud Nueva. I write about APEX, ORDS, the Oracle Database, and how AI is changing the way we build software. This blog is where I share practical examples, lessons learned, and ideas from my work.

## Responses 4

Markdown supported · ⌘↵ to post

[Carlos Benavides](https://hashnode.com/@carlosbmx)

[Dec 23, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/65877321af481c75b6cae5d0)

Please , where from can i download data set represents EV sales in California.

Regards,

[Jon Dixon](https://hashnode.com/@orclapex)

[Dec 25, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/65877321af481c75b6cae5d0#reply-65899c15e1f02b93559706f7)

You can get the data here [energy.ca.gov/files/zev-and-infrastructure-stats-…](https://www.energy.ca.gov/files/zev-and-infrastructure-stats-data)

[Carlos Benavides](https://hashnode.com/@carlosbmx)

[Dec 30, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/65877321af481c75b6cae5d0#reply-658f6e048b01e644a25923fb)

regards [Jon Dixon](https://hashnode.com/@orclapex)

[Sjahrial Sjafri](https://hashnode.com/@riesjahrial)

[Oct 12, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/6527b08a162796f09ff8e052)

MANTAP COIIIII

[Vinci Amorim](https://hashnode.com/@vamorim)

[Jun 6, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/647f266ccff67d25109eb22e)

Other cases:

-   Build "Parameterized views".
-   Improve Security when using shadow schemes.
-   Improve SQL Cache for QAPI (Query API) enforcing using the same query.

[Jon Dixon](https://hashnode.com/@orclapex)

[Jun 7, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/647f266ccff67d25109eb22e#reply-64810e96dc966543c1f9e5e2)

Nice!

[sssuarez](https://hashnode.com/@sssuarez)

[Jun 1, 2023](https://hashnode.com/posts/apex-and-pipelined-table-functions/64789b9744077fc28e32f3cf/comment/6478f3ca68c73be8bfc3fbf3)

Appreciate the use cases and comprehensive comments in your code.
