Home » SQL & PL/SQL » SQL & PL/SQL » query (Oracle9i ,Windows)
query [message #277470] Tue, 30 October 2007 04:49 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Table

origin destin

Che ban
ban kal



i want output like CHE BAN KAL

in single line
Re: query [message #277471 is a reply to message #277470] Tue, 30 October 2007 04:51 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Senior Member
Have a look at OraFAQ Forum Guide
Search for pivot.

By
Vamsi
Re: query [message #277475 is a reply to message #277470] Tue, 30 October 2007 05:13 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS_CONNECT_BY_PATH

Regards
Michel
Previous Topic: How to alter index
Next Topic: Generate trigger statement using store procedure
Goto Forum:
  


Current Time: Mon Aug 21 01:47:39 CDT 2017

Total time taken to generate the page: 0.07226 seconds