Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Publisher Idea Lab

BI Publisher For Cloud Apps - Start query "WITH"

Submitted

Views

Comments

Scott Hillier-149889 Rank 1 - Community Starter

Sep 12, 2019 12:37PM edited May 9, 2025 5:40PM in Oracle Analytics Publisher Idea Lab

AWE plc

Allow BI Publisher in Cloud Apps to have queries which start with the WITH statement

e.g :

WITH a AS

(SELECT 1, 2 FROM DUAL)

SELECT *

FROM a

Should work (in the same way as SELECT 1,2 FROM DUAL)

If we have big legacy prewritten queries, which begin WITH, then it would be good to just cut and paste them into BI Publisher.

Original Idea Number: 1d4801c5c2

1 votes