在oracle的SQL语句中有时候需要将多个字符串拼接成语句,然后执行,具体示例如下:
sqlstr :=
'create index '
|| indexname
|| ' on TB_DISARREGION_FAKEFIREPOINT(REGIONINFO) '
|| 'INDEXTYPE IS MDSYS.SPATIAL_INDEX'
|| ' PARAMETERS("TABLESPACE=GISINDEXSPACE ") NOPARALLEL';
EXECUTE IMMEDIATE sqlstr;