Home » SQL & PL/SQL » SQL & PL/SQL » display recods in cross format
display recods in cross format [message #329904] Fri, 27 June 2008 00:51 Go to next message
shakti.singh
Messages: 4
Registered: June 2008
Junior Member
in the given table record is like
col1
a
b
c
d
e
f

i want to display records in table like......
col1
a b
b c
c d
d e
e f
f

Regards,
Shakti
Re: display recods in cross format [message #329909 is a reply to message #329904] Fri, 27 June 2008 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have a look at LEAD function.

Regards
Michel
Re: display recods in cross format [message #329922 is a reply to message #329904] Fri, 27 June 2008 01:26 Go to previous message
shakti.singh
Messages: 4
Registered: June 2008
Junior Member
Thanks..Michel its working ....
Previous Topic: Cookies & pl/sql
Next Topic: How to convert row into columns
Goto Forum:
  


Current Time: Fri Feb 14 18:39:31 CST 2025