How to build an Oracle query string containing quotes

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
trobinson
Participant
Posts: 208
Joined: Thu Apr 11, 2002 6:02 am
Location: Saint Louis
Contact:
Contact trobinson

Post by trobinson »

I don't have Oracle available to me right now or I would test this myself and not waste your time should this suggestion be whacked but I gotta believe some combination of triple tick marks (definitely not double quotes) would work.

'''A690','R456','F1234'''

select * from table where codes IN (#p_in_clause#)

or

''A690','R456','F1234''

select * from table where codes IN ('#p_in_clause#')
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”