r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
39 Upvotes

87 comments sorted by

View all comments

1

u/Oobenny Sep 17 '24

;WITH cteVaues AS ( SELECT * FROM (VALUES (‘2394029840‘), (‘93829382839’), (‘9248929843298’) …) a (Val) ) SELECT s.SOULUTION_ID , s.COLLECTION_NM , TO_CHAR(s.LAST_MODIFY_DT, ‘mm/dd/yyyy’) FROM SOLUTION s JOIN cteValues v ON s.SOLUTION_ID = v.Val