Manipulating data in one or all columns of a table

How can i use Pl/Sql with opening a cursor and loop through a table an
- manipulating the data of each row in displaying only the first
character
- and displaying the table rows in a form like this

first_name1, last_name1(only the frist character) first_name1, last_name1 first_name4, last_name4 first_name7, last_name7
first_name2, last_name2 first_name5, last_name5 first_name8, last_name8
first_name3, last_name3 first_name6, last_name6 first_name9, last_name9

many thanks Received on Thu Aug 16 2001 - 07:56:17 CDT