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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS_CONNECT_BY_PATH

Regards
Michel
Previous Topic: dbms_stats for specific tables of different schemas
Next Topic: sql - index
Goto Forum:
  


Current Time: Thu Dec 08 20:07:38 CST 2016

Total time taken to generate the page: 0.19599 seconds