SQL*Plus: Release 11.2.0.4.0 Production on ?..涓€ 4?.13 17:19:55 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> set linesize 200
SQL> set pagesize 200
SQL> alter session set statistics_level=all;
Session altered.
SQL> SELECT
2 AUDIT_ID
3 FROM
4 (
5 SELECT
6 PMP_AUDIT_INFO.*, PMP_AUDIT_STEP_INFO.AUDIT_OPR_NO AUDIT_OPR_NO
7 FROM
8 PMP_AUDIT_INFO
9 JOIN PMP_AUDIT_STEP_INFO ON PMP_AUDIT_INFO.AUDIT_ID = PMP_AUDIT_STEP
FILTER 循环
最新推荐文章于 2022-10-24 21:26:00 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)