---
title: "Discussion on \"\"Function Body returning SQL Query\" with multiple queries.\" | Hashnode"
description: "Discussion on \"\"Function Body returning SQL Query\" with multiple queries.\". Here are a couple of things to consider when creating a report using a Function Body that returns an SQL Query as the data source and using \"IF\" to decide which query will be executed.\n\n\"ELSE\" must be present.\n The query in the \"ELSE\" condition will ..."
url: "https://hashnode.com/posts/function-body-returning-sql-query-with-multiple-queries/662c1188217403e4ce18f5f6"
---

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

Discussion

# ["Function Body returning SQL Query" with multiple queries.](https://epolanco.dev/function-body-returning-sql-query-with-multiple-queries?utm_source=hashnode&utm_medium=feed)

Here are a couple of things to consider when creating a report using a Function Body that returns an SQL Query as the data source and using "IF" to decide which query will be executed. "ELSE" must be present. The query in the "ELSE" condition will ...

Apr 26, 2024 · 2 min read · epolanco.dev  
Read the article

-   [#apex](https://hashnode.com/tag/apex)
-   [#oracle-apex](https://hashnode.com/tag/oracle-apex)
-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#apex-tips](https://hashnode.com/tag/apex-tips)

## Written by

[Ender Polanco Rivas](https://hashnode.com/@epolanco)

@epolanco

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

Oracle APEX Developer

## Responses 1

Markdown supported · ⌘↵ to post

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

[Jun 10, 2024](https://hashnode.com/posts/function-body-returning-sql-query-with-multiple-queries/662c1188217403e4ce18f5f6/comment/6666ea655d3075930ef8e67d)

mantap bro
