Post reply

PATINDEX & CHARINDEX

  • March 12, 2009 at 3:18 am

    #200777

    How to implement these two functions in ORACLE?

    karthik

  • March 13, 2009 at 7:44 am

    #959101

    karthikeyan (3/12/2009)

    How to implement these two functions in ORACLE?

    Hello Karthik,

    In Oracle I think you can use

    instr(YourColumntoSearch, YourSearchPattern) to replicate the functionality of both PatIndex and charIndex

    Garry

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

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