queries

1)extract middle name from a table that have single column 'DATA'  and datatype is  varchar2?

 DATA
-------------------------------
100,ANKIT KUMAR SHARMA,5,00,000
100,SMITH,8,00,000
105,MUKESH KUMAR,8,00,000

ans: select substr(data,instr(data,',',1,1)+1,length( substr(data,instr(data,',',1,1)+1))-length(substr(data,instr(data,',',1,2))) ) from source;