Oracle Space

Friday, March 31, 2017

get certain length of substring from right of string

Use this to get substring of any length (x in this case) form right side of a string.

select regexp_substr( in_string , '.{1,x}$' ) from dual
Posted by Mike at 8:44 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Mike
View my complete profile

Blog Archive

  • ►  2021 (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2020 (3)
    • ►  June (1)
    • ►  March (1)
    • ►  February (1)
  • ►  2019 (6)
    • ►  October (1)
    • ►  August (2)
    • ►  February (2)
    • ►  January (1)
  • ►  2018 (10)
    • ►  October (1)
    • ►  August (1)
    • ►  May (2)
    • ►  April (5)
    • ►  March (1)
  • ▼  2017 (8)
    • ►  November (1)
    • ►  October (1)
    • ►  June (1)
    • ▼  March (2)
      • get certain length of substring from right of string
      • Oracle Apex Classic Report Refresh and keeping pag...
    • ►  February (3)
  • ►  2016 (17)
    • ►  December (1)
    • ►  September (3)
    • ►  August (2)
    • ►  July (2)
    • ►  June (1)
    • ►  April (3)
    • ►  March (5)
Ethereal theme. Powered by Blogger.