Get multiple rows in one column

Database
Enthusiast

Get multiple rows in one column

Hi,

 

I need to convert number of rows into one coluumn 

My table DDL

 

CREATE MULTISET TABLE TEST.TABLE_ASSOCIATION    (

      Table_id INTEGER ,

      Table_Name VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      App_Name VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,

      Type_CD VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,

      Ref_Table_id INTEGER,

      Procedure_Name VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      Job_Name VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC,

      Table_DB_Name VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC,

      Ref_Table_DB_Name VARCHAR(50) CHARACTER SET LATIN NOT CASESPECIFIC)

PRIMARY INDEX  ( Table_id );

 

Ex:-

Data set i have 

Type_CD Table_DB_Name Table_Name Type_CD Table_DB_Name Ref_Table_Nmae

SRCD1T1CORED1T2
CORED2T2ENTD3T3
ENTD3T3SEMD4T4
SEMD4T4SEMD4T5
SEMD4T5nullnullnull

 

Out put required :-

D1.T1(SRC) --->D1.T2(CORE) ---> D3.T3(ENT) ---->D4.T4(SEM) ---->D4.T5(SEM)

 

Thanks

Muzammil