How can I get a value from a database(RDMS) in ArrayList?

Speaking from SQLServer perspective, you can return in the below formats

  1. Long varchar column and parsing out as a table of values

  2. XML/JSON value and parsing XML or JSON using standard functions to get result set of values

  3. Table type parameter and return values through it