Collection

Giganews Newsgroups
Subject: Collection
Posted by:  The Magnet (a…@unsu.com)
Date: Thu, 24 Jun 2010

Hi,

This query basically does that I want:

SELECT body_id, COLLECT(m_ticker) AS m_ticker
FROM  zc_body zb, zc_ticker_body zt
WHERE zb.body_id  = zt.id
AND body_id = 39
GROUP  BY body_id;

  BODY_ID
----------
M_TICKER
--------------------------------------------------------------------------------
        39
SYSTPicg9tK7GadHgQAB/AQBGww==('LNUX', 'MSFT', 'RHAT')

However, I really do not need that strange ID.  Any way to chop it
off?

Replies