oracle官方文档使用

官方地址：https://docs.oracle.com/en/database/oracle/oracle-database/index.html
1.下载11g文档资料（E11882_01.zip）如下：

2.可参考主页《New to Oracle Database 11g》
–》《New Features Guide》–》《html》了解整个文档架构，如下：

3.《4 Oracle Database 11g Documentation》

4.若查一些函数：如REGEXP_SUBSTR,NLS_UPPER
–>–><SQL and PL/SQL>
–>–><5 Functions>–
5.查函数：LISTAGG

补充：11g无WM_CONCAT
The Oracle PL/SQL WM_CONCAT function is used to aggregate data
from a number of rows into a single row, giving a list of data associated with a specific value.
In effect, it cross-tabulates a comma delimited list.

Note that WM_CONCAT is undocumented and unsupported by Oracle,
meaning it should not be used in production systems.
The LISTAGG function, which can produce the same output as WM_CONCAT is both documented and supported by Oracle.
补充2：PL/SQL与SQL区别
PL/SQL Language Reference

SQLCODE FUNCTION

PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax.
PL/SQL program units are compiled by the Oracle Database server and stored inside the database.
And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency.
PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database.