How to select an Oracle database table from remote database that has CLOB field?

smallwei 3:06 pm on October 17, 2009 | Answers: 1    
Tags: clob, database (51), field (8), oracle (136), oracle database table (2), table (16)

Rate Knowledge:

 Loading ...

• smallwei 3:08 pm on October 17, 2009
  

  2 methods:

  1) create a view on the remote site that selects the dbms_lob.substr. You can then select from that view over the dblink.

  2) using a temporary table, copy the lob over to work with it. For example:

  > create global temporary table foo ( x clob );

  Table created.

  > insert into foo select x from t@source_db;

  1 row created.

  > select * from foo;

  X
  ——————————————————————————–
  Hello World

  http://bit.ly/f19Ew