Forum Discussion

elise_henschen's avatar
elise_henschen
New Contributor III
9 years ago

Escaping special characters in Oracle - Execute

We have an Oracle table that we’re trying to use an Execute snap on. The column names contain $ (t$field is the actual name), which seems to be throwing it off. I’ve tried the following ways, but the...
sriram's avatar
sriram
Former Employee
9 years ago
Copy Link

If your Oracle table has columns whose names contain a ‘$’ (or any other special character) in it, here’s how the execute query needs to look like:

Query: select “USER$ID” from testtable1


Note: Expression should not be enabled on the “Oracle Execute” snap