如何在PACKAGE里面创建function来抓取数据
- 先创建表APPS.SCHOOL_STUDENT
CREATE TABLE APPS.SCHOOL_STUDENT
(
STUDENT_NAME VARCHAR2(10 BYTE) NOT NULL,
STUDENT_ID NUMBER NOT NULL,
STUDENT_GENDER VARCHAR2(5 BYTE),
STUDENT_AGE NUMBER,
STUDENT_GRADE VARCHAR2(10 BYTE),
STUDENT_CLASS VARCHAR2(15 BYTE),
CREATION_DATE DATE NOT NULL,
CREATED_BY NUMBER NOT NULL,
LAST_UPDATE_DATE DATE NOT NULL,
LAST_UPDATED_BY NU