Column(First_nm,Last_nm) = Column(First_nm)and Column(Last_nm)

select column_nm,
substr( column_nm ,1,instr( column_nm , ',') - 1) First_nm,
trim(substr( column_nm ,instr ( column_nm, ',')+1)) last_nm
 from table_nm