...

One Row to Multiple Rows – Case 2

 
SQL(179)

【Question】
Here’s column1:
column1
01,02,03

The expected result:
01
02
03
Is there a one-liner solution without using the stored procedure?

 

【Answer】
It’s not easy to covert a row to multiple rows in any database. But with SPL (Structured Process Language) it becomes easy:

A

1

=demo.query("selct column1   from tb1").(column1.split@c()).conj()

esProc provides JDBC interface to function like a database. See How to Call an SPL Script in Java. 


SQL(179)
 
 •  377 View  •