12/01/2018

Row to Column in Oracle

Row to Column in Oracle

The easiest solution for pivot the row with delimiter to column.

select
  regexp_substr('1,2,3,4,5','[^,]',level)
from dual
connect by regexp_substr('1,2,3,4,5','[^,]',1,level) is not null
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Generate test data with Oracle simple query

The most easiest way to generate test data in the Oracle is the method of using CONNECT BY LEVEL with the package DBMS_RANDOM. With the quer...