![]() |
Hello, I am trying to use the Oracle UDFs provided by teradata in my TPT script. The problem I am facing is with the use of single quotes " ' " inside my insert part of my apply. since the INSERT statement within the APPLY has to be contained within " ' "(single quotes) I cannot use the "nvl" udf that requires the replacement string to be in " ' ". Example: 'Insert into table1 values ( nvl(:column, 'replacement string'));' If anyone knows the escape character that may be used to escape the " ' " enclosing the "replacement string" then please help me.
20 Jun 2011
| 2 comments
,
|