SQL_ESCAPE_STRING¶
Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex
This command is used to properly escape strings before they are used in embedded SQL statements. This can be extremely important when you do not have full control of the strings being passed to the SQL statement as this will ensure that the strings are properly quoted.
Syntax
SQL_ESCAPE_STRING of {string} to {variable}
Parameter |
Description |
|---|---|
string |
The string to be escaped. |
variable |
Variable to hold the newly escaped string |
Example
SQL_ESCAPE_STRING of "They said to me, 'hello'." to sEscaped