Question

oracle怎样将动态sql插到字段中去单引号里面包含单引号报错

UPDATE r_de
SET where_name = '末梢渠道',
power_right = '100',
power_sql = 'select null org_id,'所有' bwq_name from dual union all
select distinct org_id,org_name from dmsqdmsg',
no_power_sql = 'select null org_id,'所有' bwq_name from dual union all
select distinct org_id,org_name from dmsqdmsg',
where_sts = 'Y',
memo = '末梢渠道',
op_id = 'pmtech',
op_time = '2016-10-11 09:56:36'
WHERE
where_code = 'yd_ms_org_id'
update r_swherecode set where_name='末梢渠道',power_right='100',
power_sql=q'<select null org_id,'所有' bwq_name from dual union all
select distinct org_id,org_name from dmsqdmsg>',
no_power_sql= q'<select null org_id,'所有' bwq_name from dual union all
select distinct org_id,org_name from dmsqdmsg>',where_sts='Y',
memo='末梢渠道',op_id='pmtech',op_time='2016-10-11 09:56:36'
where where_code='yd_ms_org_id';

Answer 1

要用2个'来转换字符串中的单个'.
即：
power_sql = 'select null org_id,''所有'' bwq_name from dual union all