Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Publisher For Cloud Apps - Start query "WITH"
Scott Hillier-149889
Rank 1 - Community Starter
Organization Name
AWE plc
Description
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)
Use Case and Business Need
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