PL/SQL (MOSC)

MOSC Banner

Select CLOB data via database link

edited Sep 13, 2018 10:58PM in PL/SQL (MOSC) 3 commentsAnswered ✓

Hi all,

I have a SQL statement to query data from remote table by using database link. This table have a CLOB datatype, so my query select <clob_value_field> from <remote_table>@&lt;db_link> has failed.

I have checked some links, I can create table with CAS (create ... as select ...) in local database then query data from it. But if this table have a huge data, so creating table with CAS will take more time. Do we have other solutions for querying clob data from remote table ?

My oracle version is 12c.

Thanks,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center