【快问快答】如何收集回看sql语句中传入的绑定变量值

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SQL_BIND_CAPTURE.html#GUID-D353F4BE-5943-4F5B-A99B-BC9505E9579C
One of the bind values used for the bind variable during a past execution of its associated SQL statement. Bind values are not always captured for this view. Bind values are displayed by this view only when the type of the bind variable is simple (this excludes LONG, LOB, and ADT data types) and when the bind variable is used in the WHERE or HAVING clauses of the SQL statement.

    CREATE AUDIT POLICY all_emp
      ACTIONS DELETE on scott.emp,
              INSERT on scott.emp,
              UPDATE on scott.emp,
              ALL on scott.emp;

    SQL> AUDIT POLICY ALL_EMP;
     
    SQL> set line 900
    SQL> select POLICY_NAME,OBJECT_NAME from AUDIT_UNIFIED_POLICIES where OBJECT_SCHEMA = 'SCOTT';
     
    POLICY_NAME                                                                                                                      OBJECT_NAME
    -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
    ALL_EMP                                                                                                                          EMP
    ALL_EMP                                                                                                                          EMP
    ALL_EMP                                                                                                                          EMP
    ALL_EMP                                                                                                                          EMP
     
    SQL> select * from audit_unified_enabled_policies where policy_name = 'ALL_EMP';
     
    USER_NAME                                                                                                                        POLICY_NAME                                                                                                                       ENABLED ENABLED_OPTION  ENTITY_NAME                                                                                               ENTITY_ SUC FAI
    -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------- --------------- -------------------------------------------------------------------------------------------------------------------------------- ------- --- ---
    ALL USERS                                                                                                                        ALL_EMP                                                                                                                   BY      BY USER          ALL USERS                                                                                                        USER    YES YES
     

    SQL> var v_empno number;
    var v_ename nvarchar2(8);
    exec :v_empno := 700;
    exec :v_ename := 'chris';
    insert into emp (empno,ename) values (:v_empno,:v_ename);SQL> SQL>
    PL/SQL procedure successfully completed.
     
    SQL>
    PL/SQL procedure successfully completed.
     
    SQL>
     
    1 row created.
     
    SQL> select SQL_TEXT,SQL_BINDS from unified_audit_trail order by EVENT_TIMESTAMP;
     
    insert into emp (empno,ename) values (:v_empno,:v_ename)
     #1(3):700 #2(10): c h r i s