7 Replies Latest reply: Feb 11, 2013 12:10 AM by rp0428 RSS

    Using long data type

    950462
      Hi Experts,

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

      'my data is '||Long_Column
      Substr(Long_Column,2,50)
      Replace(Long_Column,'x','y')

      Is there any solution available to perform such operations using only SQL.
      Note:-
      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