Magic column


The magic VARCHAR2 column in 9.2

SQL> show user
USER is "SCOTT"
SQL> desc v$vpd_policy
 Name                            Null?    Type
 ------------------------------- -------- ----------------------
 ADDRESS                                  RAW(8)
 PARADDR                                  RAW(8)
 SQL_HASH                                 NUMBER
 CHILD_NUMBER                             NUMBER
 OBJECT_OWNER                             VARCHAR2(30)
 OBJECT_NAME                              VARCHAR2(30)
 POLICY_GROUP                             VARCHAR2(30)
 POLICY                                   VARCHAR2(30)
 POLICY_FUNCTION_OWNER                    VARCHAR2(30)
 PREDICATE                                VARCHAR2(4000)

... so far, so good...

SQL> conn / as sysdba
Connected.
SQL> desc v$vpd_policy
 Name                            Null?    Type
 ------------------------------- -------- ----------------------
 ADDRESS                                  RAW(8)
 PARADDR                                  RAW(8)
 SQL_HASH                                 NUMBER
 CHILD_NUMBER                             NUMBER
 OBJECT_OWNER                             VARCHAR2(30)
 OBJECT_NAME                              VARCHAR2(30)
 POLICY_GROUP                             VARCHAR2(30)
 POLICY                                   VARCHAR2(30)
 POLICY_FUNCTION_OWNER                    VARCHAR2(30)
 PREDICATE                                VARCHAR2(4096)  !!!!!