plain sql
select first_name,substr(last_name,1) from ... order by..
Jim
"Paul Ehm" <ehm_at_fhnon.de> wrote in message
news:3B7BC2F1.27627837_at_fhnon.de...
> 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:50:46 CDT
