Re: List item' query - Forms 5

See LPAD or RPAD function... this will give you the answer

Olivier Régis
MCSE+I, Oracle CP
Switzerland

wozi <wozi_at_dhc.net> wrote in message
news:49BC5500BD558C51.175C7AA794269B7F.609D6E4F3AE60E1F_at_lp.airnews.net...
> I am using the following code to populate a list item, but I like the
output
> to be different.
>
> --Build the SQL statement.
> sql_stat := 'SELECT make||'' ''||model, vin FROM auto';
>
> Populate_the_List(list_id, sql_stat);
>
> here is a sample output: here is what I like to see:
> Mazda 929 Mazda 929
> Isuzu Troper Isuzu Tropper
> Ford Escort Ford Escort
> Honda Accord Honda Accord
>
> any help with constructing the query?
>
>
Received on Fri Nov 05 1999 - 10:14:51 CET