首頁/2021-05-07 - MoinMoin DesktopEdition

Describe 首頁/2021-05-07 here.
PROCDURE

SQL> CREATE OR REPLACE PROCEDURE test_proc
  2  AS
  3  BEGIN
  4   FOR x IN ( SELECT col1, col2 FROM test_table )
  5  LOOP
SQL> column OBJECT_NAME  format a20;
SQL> set linesize 100;
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC';

OBJECT_NAME          STATUS
-------------------- --------------
TEST_PROC            VALID

SQL> ALTER TABLE test_table ADD col3 NUMBER;

Table altered.

SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC';

OBJECT_NAME          STATUS
-------------------- --------------
TEST_PROC            VALID

SQL> ALTER TABLE test_table MODIFY col1 VARCHAR2(20);

Table altered.

SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC';

OBJECT_NAME          STATUS
-------------------- --------------
TEST_PROC            INVALID

SQL> EXECUTE test_proc

PL/SQL procedure successfully completed.

SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC';

OBJECT_NAME          STATUS
-------------------- --------------
TEST_PROC            VALID