IT技术博客

 首先我创建一个包体，代码如下：

CREATE OR REPLACE PACKAGE plch_pkg

IS

   my_resolution VARCHAR2(30) := 'Turn off the TV';

END;

/

执行完以下哪几个选项后，屏幕会显示” Turn off the TV”

选项1：

BEGIN

   EXECUTE IMMEDIATE

      'begin dbms_output.put_line (plch_pkg.my_resolution); end;';

END;

/

选项2：

BEGIN

   DBMS_OUTPUT.put_line (plch_pkg.my_resolution);

END;

/

选项3：

SELECT plch_pkg.my_resolution FROM DUAL

/

选项4：

DECLARE

   l_resolution   plch_pkg.my_resolution%TYPE;

BEGIN

   EXECUTE IMMEDIATE 'select plch_pkg.my_resolution from dual'

      INTO l_resolution;


   DBMS_OUTPUT.put_line (l_resolution);

END;

/

选项5：

DECLARE

   l_resolution   plch_pkg.my_resolution%TYPE;

BEGIN

   SELECT plch_pkg.my_resolution INTO l_resolution FROM DUAL;


   DBMS_OUTPUT.put_line (l_resolution);

END;

/

答案：http://www.anguora.com/plsql挑战答案/