CLOB To BLOB

I want to read a clob data from table and post that value in blob data field of another table . How can i do this ?
 

TableA (having clob data field
F1 )
TableB (having BLOB datafield F2)
update  TableB
set F2= (select F1 from TableA where
condition1)
where condition2.
 

Here  <FONT face=Arial
size=2>condition1 insures that it will return only one record at a time.
 
 

Shishir Kumar MishraAgni Software (P)
Ltd., Received on Mon Nov 19 2001 - 02:46:36 CST