17,140
社区成员




DECLARE
P_DBLINK VARCHAR2(128) := 'AA';
V_SQL VARCHAR2(10000);
V_SERVERNAME VARCHAR2(128);
BEGIN
V_SQL := 'SELECT NAME FROM INSTANCES WHERE LINK =''' || P_DBLINK || '''';
EXECUTE IMMEDIATE V_SQL
INTO V_SERVERNAME;
DBMS_OUTPUT.PUT_LINE(V_SERVERNAME);
END;
/
[Quote=引用楼主 zdljj 的帖子:]