Community Patterns

Community Library Entry

0

Regular Expression
Created·2023-03-06 08:15
Flavor·Java

"
(?<type>[a-zA-Z2]*)(\((?<precision>\d*)(,(?<scale>\d*))?\))?
"
gms
Open regex in editor

Description

Database data type determination and extraction. Example:

  • varchar(20)
  • varchar2(20)
  • number(20,3)
  • timestamp
  • Varchar(20)
Submitted by anonymous