目前,我已经创建了一个PLSQL函数,它可以显示如下。
SELECT Display(R_NAME) FROM REGION WHERE R_REGIONKEY IN (SELECT R_REGIONKEY FROM REGION);
终端输出:
0 AFRICA: ALGERIA, ETHIOPIA, KENYA, MOROCCO, MOZAMBIQUE,
1 AMERICA: ARGENTINA, BRAZIL, CANADA, PERU, UNITED STATES,
2 ASIA: INDIA, INDONESIA, JAPAN, CHINA, VIETNAM,
3 EUROPE: F