oracle cast （一）

A : 

 select *
from the (SELECT cast(DS4.SPLIT(TC_PLCKEX2005, ',') as
                                              stringTable)
                                    FROM DS4.TC_PLCKEX2_FILE
                                   WHERE TC_PLCKEX2001 = 'B530C')

B:

select *from table(split('fas,asdf,asdf',','))