#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2014
    Posts
    20
    Rep Power
    0

    Wink Retain and Swap characters in oracle


    Hi All, I have two requirements.. First Requirement : Swap the first three characters in a string example : ABRAHAM LINCOLN OUTPUT RBAAHAM LINCOLN SECOND REQUIREMENT Retain the first 10 characters in a string and swap the remaining letters in the string OUTPUT ABRAHAM TOYNRGGENO Do we have any inbuilt functions to do this. Appreciate everyone's help in this matter. Thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2014
    Posts
    20
    Rep Power
    0
    second requirement example used is ABRAHAM TONYGREGON

IMN logo majestic logo threadwatch logo seochat tools logo