Home » SQL & PL/SQL » SQL & PL/SQL » Query to display a column value into multiple rows[Merged]
Query to display a column value into multiple rows[Merged] [message #414255] Tue, 21 July 2009 04:09 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Hi Everybody,

I have a column which is having all comma separated values.
Now, i want to display each value into a individual row.

Please find my example.

Quote:

VAL
---
a,b,c,d,e,f,



Now i want to display in the following format.

Quote:

VAL
---
a
b
c
d
e
f



Please help me in resolving the query.

Thanks in Adv.

Natesh
Re: Query to display a column value into multiple rows[Merged] [message #414263 is a reply to message #414255] Tue, 21 July 2009 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
FAQ
Please search BEFORE posting.

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: Query to display a column value into multiple rows[Merged] [message #414368 is a reply to message #414255] Tue, 21 July 2009 17:26 Go to previous message
SnippetyJoe
Messages: 63
Registered: March 2007
Location: Toronto, Canada
Member

See SQL Snippets: SQL Techniques Tutorials - String to Rows.

--
Joe Fuda
SQL Snippets

Previous Topic: Query using
Next Topic: Compilation error while CREATE FUNCTION
Goto Forum:
  


Current Time: Sun Dec 04 06:41:28 CST 2016

Total time taken to generate the page: 0.07485 seconds