Hi,
I was just trying to format an o/p of a table, and while looking at the result I thought it would be nice to append a peice of a String to the last record. For example
with dat as (
select 'First Record' as COL from DUAL
union all
select 'Second Record' from DUAL
union all
select 'Third Record' from DUAL
union all
select 'Nth Record' from DUAL )
select * from dat
o/p Desired o/p
COL COL
------------- -------------
first RECORD first RECORD
second RECORD second RECORD
THIRD RECORD THIRD RECORD
NTH RECORD This is the last record NTH RECORD