3a.1.95. Remote Peering Connections (OCI360_REMOTE_PEERING)

#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 COMPARTMENT_ID                                                                               VARCHAR2(1)
 DISPLAY_NAME                                                                                 VARCHAR2(1)
 DRG_ID                                                                                       VARCHAR2(1)
 IS_CROSS_TENANCY_PEERING                                                                     VARCHAR2(1)
 LIFECYCLE_STATE                                                                              VARCHAR2(1)
 PEER_ID                                                                                      VARCHAR2(1)
 PEER_REGION_NAME                                                                             VARCHAR2(1)
 PEER_TENANCY_ID                                                                              VARCHAR2(1)
 PEERING_STATUS                                                                               VARCHAR2(1)
 TIME_CREATED                                                                                 VARCHAR2(1)
 ID                                                                                           VARCHAR2(1)


SELECT t1.*
FROM   OCI360_REMOTE_PEERING t1
WHERE  substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';


0 rows selected.