Post reply

Oracle to SQL Server

  • March 26, 2004 at 12:23 am

    #107494

    How can we migrate the below which is in Oracle in SQL Server

    -- BLOB JUNK

    AMOUNT := DBMS_LOB.GETLENGTH(REC.BLOB_ITEM)

  • March 26, 2004 at 4:34 am

    #500601

    Sorry to ask you this question , But can explain what does this statement do? Does it assign the length of the column with blob datatype to amount or something like that?

    Thanks

     

    Prasad Bhogadi
    www.inforaise.com

  • March 26, 2004 at 4:57 am

    #500606

    Try

     

    amount = datalength(tblname.field)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply