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',','))

 

 

转载于:https://www.cnblogs.com/Mayvar/archive/2011/06/17/wanghonghua_201106170331.html