Is there anything wrong with storing SELECT statements in a table.

Is there anything wrong with storing SELECT statements in a table.

Like the question asked on https://forums.oracle.com/forums/thread.jspa?messageID=4228161
Mr_ShawAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Yes, if there is no necessity to dynamically form queries, then there is no need for that table.
But if you need to dynamically form queries which should be much customizable, then you can have a table like that..
0
 
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
It depends upon the scenario..
If you want to create your SELECT statements dynamically based on several parameters, then you can store the base SELECT query in the table and then add WHERE clauses and ORDER BY clauses dynamically..
0
 
Mr_ShawAuthor Commented:
The C# devs who I work with joked about the table.....but I can't see anything really bad about it.
0
 
Mr_ShawAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.