Regular Expressions 101

Community Patterns

1...34567...585

Database datatype check

0

Regular Expression
Java 8

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

Description

Database data type determination and extraction. Example:

  • varchar(20)
  • varchar2(20)
  • number(20,3)
  • timestamp
  • Varchar(20)
Submitted by anonymous - a year ago