Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> blob

blob

From: Sajid Iqbal <siqbal_at_vianetworks.co.uk>
Date: Fri, 5 Jan 2001 11:12:20 +0000 (GMT)
Message-Id: <10732.125816@fatcity.com>


How do read from a BLOB?

sw_basic_script.swText is a blob

      SELECT swname
      FROM SW_BASIC_SCRIPT
      WHERE swText like 'VAPP%'

I've tried to_char, substr.  

Any Ideas

-- 
Sajid Iqbal
Database Administrator

VIA NET.WORKS
620 Birchwood Boulevard
Birchwood
Warrington
WA3 7QZ
DDI: +44 (0) 1925 484485  Fax: +44 (0) 1925 484466
Email: siqbal_at_vianetworks.co.uk
Website: http://www.vianetworks.co.uk

local touch global reach
Received on Fri Jan 05 2001 - 05:12:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US