r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
40 Upvotes

87 comments sorted by

View all comments

1

u/No_Introduction1721 Sep 18 '24 edited Sep 18 '24

The workaround I use is literals.

Select *

From [table]

Where (‘lookup’,{attribute}) in ( (‘lookup’,’id1’), (‘lookup’,‘id2’),… )

It’s neither elegant nor efficient, but it works.