Prev: General SAN advice needed for 2TB 9.2.0.8 database on HP-UX
Next: understanding oracle terminology - instance, database, sid, schema
From: The Magnet on 24 Jun 2010 11:07

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?
 | 
Pages: 1
Prev: General SAN advice needed for 2TB 9.2.0.8 database on HP-UX
Next: understanding oracle terminology - instance, database, sid, schema