What are some commonly used string functions in Oracle?

  1. SUBSTR: used to extract a substring from a string
  2. INSTR: Used to determine the position of a substring within a string.
  3. CONCAT: used to join two strings.
  4. LENGTH: used to determine the size of a string.
  5. TRIM: Used to remove spaces or specified characters from a string.
  6. UPPER: used to convert a string to uppercase
  7. LOWER: used to convert a string to lowercase
  8. REPLACE: Used to substitute a substring in a string
  9. LPAD and RPAD are used to pad a string with a specified character on the left and right side, respectively.
  10. Translate: Used to replace specified characters in a string with another character.
Leave a Reply 0

Your email address will not be published. Required fields are marked *


广告
Closing in 10 seconds
bannerAds