oracle dblink 如何删除视图
CREATE VIEW TEST_V AS
SELECT
utl_raw.cast_to_raw(DJ_NSRXX.NSRMC) nsrmc
FROM
DJ_NSRXX@LANDTAXDBLINK
drop view TEST_V@landtaxdblink 删除会提示
oracle dblink? 视图
[解决办法]
DECLARE FLAG NUMBER;
BEGIN
SELECT COUNT(1) INTO FLAG FROM user_views@LANDTAXDBLINK s WHERE s.view_name = 'yourViewName';
IF FLAG = 1 THEN
dbms_utility.exec_ddl_statement@LANDTAXDBLINK('drop VIEW yourViewName');
END IF;
END;
