7 Replies Latest reply on Feb 11, 2013 6:10 AM by rp0428

    Using long data type

      Hi Experts,

      I need to use a column (which has data type LONG ) in expression or function, for example

      'my data is '||Long_Column

      Is there any solution available to perform such operations using only SQL.
      it is not about only SubString the LONG. I need to use such columns in various expressions, like Replace, Concatenation, Case/Decode statements etc. etc.

      Edited by: 947459 on Feb 8, 2013 12:13 AM