Home » SQL & PL/SQL » SQL & PL/SQL » formating the query output
formating the query output [message #198385] Mon, 16 October 2006 23:32 Go to next message
manyal
Messages: 77
Registered: March 2005
Member
Dear Friends


my query returns date like below

Name Age DOB
Manish 32 14-09-74
Devendra 30 14-09-77



now i want the result in this format

Manish,32,14-09-74
Devendra,30,14-09-77

i mean columns should be separated by , and no space is required amongst them


Thanx in advance!!!


Manyal
Re: formating the query output [message #198397 is a reply to message #198385] Tue, 17 October 2006 01:08 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Hi Manyal,
Why don't you try concatenating the columns with ||','||

By
Vamsi.
Re: formating the query output [message #198401 is a reply to message #198397] Tue, 17 October 2006 01:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Yep, concatenation is one way. You could also opt for the SQL*Plus command
SET COLSEP ','


MHE
Re: formating the query output [message #198402 is a reply to message #198397] Tue, 17 October 2006 01:28 Go to previous message
manyal
Messages: 77
Registered: March 2005
Member
Dear Vamsi,

good idea!!
may problem is solved now.


manyal
Previous Topic: Top values in same line
Next Topic: Too many Commits
Goto Forum:
  


Current Time: Sun Dec 04 20:27:07 CST 2016

Total time taken to generate the page: 0.09889 seconds