Home › Database › Oracle › Oracle QUOTE function: Use to avoid complicated escape character sequences

Oracle QUOTE function: Use to avoid complicated escape character sequences

Posted on Posted in Oracle Tagged with , ,

Rather than fret about how to escape 2 single quotes for example, just use the quote function and native text:

QUOTE: q'{}’;

vSQL := q'{ALTER TABLE DIM_ISSUE ADD (CONSTRAINT DIM_ISSUE_C9 CHECK (length(regexp_replace(UPPER(issue_name),'[ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789_]’,”)) = 0 AND regexp_like(issue_name,’^[ABCDEFGHIJKLMNOPQRSTUVWXYZ]+.*$’)))}’;
EXECUTE IMMEDIATE(vSQL;)