Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /mnt/web018/d2/82/51207682/htdocs/armbruster-it/joomla33/templates/stefans_blog_05/functions.php on line 182
... to user2015502 for this very smart solution in StackOverflow
SELECT (select from @ where ...) AS blob_column FROM DUAL;
select BLOB_COLUMN from SAMPLE_TABLE_WITH_BLOB@REMOTE_SERVE ...
From time to time I will be faced the problem to move data from one table to another. Under normal circumstances this is not a big deal, but if the source table contains a long-/raw column this is impossible ...
... We create a foreign key constraint on that view
alter view test_view_dblink
add constraint test_view_dblink_fk foreign key (column_name)
references table_in_local_database(column_name) disable;