Home » SQL & PL/SQL » SQL & PL/SQL » Regd CONCAT_ALL
Regd CONCAT_ALL [message #245870] Tue, 19 June 2007 02:06 Go to next message
sibgat
Messages: 45
Registered: November 2006
Location: Chennai
Member

Hi,
When i try to execute the below sql

 SELECT DEPTNO,CONCAT_ALL(DNAME) FROM DEPT GROUP BY DEPTNO

i got the below error,
ORA-00904: "CONCAT_ALL": invalid identifier

is concat_all is available in ORACLE 10g ?

Thanks in advance,
Regards
Sib
Re: Regd CONCAT_ALL [message #245884 is a reply to message #245870] Tue, 19 June 2007 02:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not a built-in package.
Search here you'll find the source.

Regards
Michel
Re: Regd CONCAT_ALL [message #245899 is a reply to message #245884] Tue, 19 June 2007 03:37 Go to previous messageGo to next message
sibgat
Messages: 45
Registered: November 2006
Location: Chennai
Member

Thanks a lot
Regards
Sib
Re: Regd CONCAT_ALL [message #245919 is a reply to message #245899] Tue, 19 June 2007 05:12 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member

Here is a link to one of the places where the original concat_all function was posted:

http://www.orafaq.com/forum/m/34541/43710/?srch=concat_all#msg_34541

.
Re: Regd CONCAT_ALL [message #246063 is a reply to message #245870] Tue, 19 June 2007 13:34 Go to previous message
SnippetyJoe
Messages: 63
Registered: March 2007
Location: Toronto, Canada
Member
You might also be interested in the tutorials at SQL Snippets: SQL Techniques Tutorials - Rows to String. They describe various Oracle string concatenation techniques.

--
Joe Fuda
SQL Snippets
Previous Topic: Foreign key on updating
Next Topic: Create simple view
Goto Forum:
  


Current Time: Sat Dec 03 13:42:14 CST 2016

Total time taken to generate the page: 0.04504 seconds