how to convert $enter to informix in oracle
Posted in 2008
Hi, In oracle , if you want to concat a 'enter' into the string, you could use the following syntax, for example: v_sql:= ' create or replace trigger $trigger_name after insert or delete or update on $table_name for each row $enter '|| ' declare $enter '|| ' c_flag varchar2(10); $enter '|| ' begin $enter '|| ' c_flag :="新增"; $enter '|| ' if deleting then $enter '|| ' c_flag := "删除"; $enter '|| ' elsif updating then $enter '|| ' c_flag := "修改"; $enter '|| ' end if; $enter '|| ' if c_flag = "新增" then $enter '|| ' insert into table_operation_log $enter '|| ' values ("$table_name",c_flag,sysdate,null,$v_new_value,SYS_CONTEXT("USERENV","HOST"),SY S_CONTEXT("USERENV","IP_ADDRESS")); $enter '|| ' end if; $enter '|| ' if c_flag = "删除" then $enter '|| ' insert into table_operation_log $enter '|| ' values ("$table_name",c_flag,sysdate,$v_old_value,null,SYS_CONTEXT("USERENV","HOST"),SY S_CONTEXT("USERENV","IP_ADDRESS")); $enter '|| ' end if; $enter '|| ' if c_flag = "修改" then $enter '|| ' insert into table_operation_log $enter '|| ' values ("$table_name",c_flag,sysdate,$v_old_value,$v_new_value,SYS_CONTEXT("USERENV","H OST"),SYS_CONTEXT("USERENV","IP_ADDRESS")); $enter '|| ' end if; $enter '|| ' update tp_param_status $enter '|| ' set modify_status = 1 $enter '|| ' where lower(table_name) = lower("$table_name"); $enter '|| ' end; '; do you know how to replace the '$enter' in informix? thanks in advance.