Posts by L_TX • 1 point

• 0

  votes

  1

  answer

  27

  views

  A: PL/SQL Return specific value of a variable string

  As @Motta mentioned The following resolution: SELECT substr(params, instr(PARAMS, 'refDate'),17) as dt_ref FROM xxxxxxxxxxxxx where start_date between '04/01/21 00:00:00' and '20/01/21 00:00:00' and…

  sql string pl-sql

  answered 3 years, 8 months ago L_TX 1

• 0

  votes

  1

  answer

  27

  views

  Q: PL/SQL Return specific value of a variable string

  I need to separate specific information from a string within a field, in case only the value "refDate:dd:mon:yy", but the string varies in each record. How could it bring about the desired result?…

  sql string pl-sql

  asked 3 years, 8 months ago L_TX 1