Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

if possible to use static strings as variable for long query

Jian-cdoOct 15 2021

Hello,
I have an interactive report with a super long query, in which it has dynamic statement based on different studies, then for each study it has a very long case when clause (at least 200 characters for each study). I don't know how many characters I can have for a sql query since we have over a dozen studies to handle, wonder if it's possible I can store the case when part for each study as a static parameter, then later feed it into the sql query when the study_id is passed. Although later it will still compose a big query to send to the database, but if it will be easier to maintain the query. Thanks.

This post has been answered by Frank Kulash on Oct 15 2021
Jump to Answer

Comments

Processing

Post Details

Added on Oct 15 2021
4 comments
69 views