I have a MS SQL statement that I need to have converted to Oracle. I would do it myself except I don't have access to an Oracle environment to work in.
CAST([Event_Detail_Value] AS VARCHAR(256)) AS Event_Detail_Value2
Event_Detail_Value is a BLOB or CLOB in Oracle.
I only need the first 256 characters from it. I assume if I need more it will just require changing 256 to 1000.