3,491
社区成员
发帖
与我相关
我的任务
分享
V_SQL := 'TIMEID >= :V_TIMEID AND
TIMEID < :V_TIMEID_END
PARTITION(:V_PART) A,
PARTITION(:V_PART_MONTH) B,
PARTITION(:V_PART_MONTH) C,
PARTITION(:V_PART_MONTH) D';
[Quote=引用 3 楼 的回复:]
SQL code
with regexp_test(str) as (
select 'V_TIMEID' from dual
union
select 'V_TIMEID_END' from dual
union
select 'V_PART' from dual
union
select 'V_PART_MONTH' from dual
)
select str,REGEXP_REPLA……
[/Quote]
with regexp_test(str) as (
select 'V_TIMEID' from dual
union
select 'V_TIMEID_END' from dual
union
select 'V_PART' from dual
union
select 'V_PART_MONTH' from dual
)
select str,REGEXP_REPLACE(REGEXP_REPLACE(str,'^V_TIMEID$','201205010000'),'^V_PART$','PART_20120501') as replaced from regexp_test t
/
STR REPLACED
------------ --------------------
V_PART PART_20120501
V_PART_MONTH V_PART_MONTH
V_TIMEID 201205010000
V_TIMEID_END V_TIMEID_END