5a.362. Policies (OCI360_POLICIES)

#	ID	NAME	DESCRIPTION	TIME_CREATED	COMPARTMENT_ID	LIFECYCL
1	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000589	PSM-root-policy	PSM managed compartment root policy	2020-03-03T23:44:36.635000+00:00	ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686	ACTIVE
2	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000590	Usage_Report	Rules to enable Usage_Report in compartment	2020-05-05T16:01:39.453000+00:00	ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686	ACTIVE
3	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000591	oci360_policy	Policy used for OCI360	2020-05-20T14:08:00.719000+00:00	ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686	ACTIVE
4	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000592	OS_Management_Service	OS Management Service policies	2020-04-24T20:47:47.611000+00:00	ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686	ACTIVE
5	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000593	Tenant Admin Policy	Tenant Admin Policy	2020-03-03T23:33:34.012000+00:00	ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686	ACTIVE
6	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000594	Key_Management	Rules to encrypt using Key Management Service	2020-04-25T20:56:08.195000+00:00	ocid1.tenancy.oc1..000000000000000000000000000000000000000000000000000000000686	ACTIVE
7	ocid1.policy.oc1..000000000000000000000000000000000000000000000000000000000595	PSM-mgd-comp-policy	PSM managed compartment policy	2020-03-03T23:44:36.635000+00:00	ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000228	ACTIVE

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 NAME                                                                                         VARCHAR2(32)
 DESCRIPTION                                                                                  VARCHAR2(64)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                           VARCHAR2(64)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                           VARCHAR2(32)
 TIME_CREATED                                                                                 VARCHAR2(32)
 VERSION_DATE                                                                                 VARCHAR2(4)
 COMPARTMENT_ID                                                                               VARCHAR2(128)
 INACTIVE_STATUS                                                                              VARCHAR2(4)
 LIFECYCLE_STATE                                                                              VARCHAR2(8)
 STATEMENTS                                                                                   VARCHAR2(256)


SELECT distinct
       ID,
       NAME,
       DESCRIPTION,
       TIME_CREATED,
       VERSION_DATE,
       COMPARTMENT_ID,
       INACTIVE_STATUS,
       LIFECYCLE_STATE
FROM   OCI360_POLICIES t1;


7 rows selected.