How to handle a single quote in Oracle SQL with long text -

how insert record in column having clob data type(so big text) having single quote in it?

i've seen

but solution make manual , i'm trying insert long text contains lot of single quotes. once oracle detects ', insert doesn't work.

my question if there kind of command "set define off" can tell oracle disable ' in text

try q' operator; example:

create table t_clob ( clob)  insert t_clob values (q'[start aa'a''aa aa 'a'' aa'a'  a'a' end]')

Live one