3a.1.99. Private IPs (OCI360_PRIVATEIPS)

#	COMPARTMENT_NAME	VCN_NAME	SUBNET_NAME	IP_ADDRESS	IS_P	DISPLAY_NAME	TIME_CREATED	HOSTNAME_LABEL	AVAILABILITY_DOMAIN	VNIC_ID	ID
1	compt_ss_net	vcn_dev	subnet_dev_dmz	10.100.4.2	true	oci360comp	2020-05-20T14:54:11.550000+00:00	oci360comp	CYtq:US-ASHBURN-AD-3	ocid1.vnic.oc1.iad.000000000000000000000000000000000000000000000000000000000706	ocid1.privateip.oc1.iad.000000000000000000000000000000000000000000000000000000000596

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 VNIC_ID                                                                                      VARCHAR2(128)
 SUBNET_ID                                                                                    VARCHAR2(128)
 IP_ADDRESS                                                                                   VARCHAR2(16)
 IS_PRIMARY                                                                                   VARCHAR2(4)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDBY                                                           VARCHAR2(64)
 DEFINED_TAGS$ORACLE_TAGS$CREATEDON                                                           VARCHAR2(32)
 DISPLAY_NAME                                                                                 VARCHAR2(16)
 TIME_CREATED                                                                                 VARCHAR2(32)
 COMPARTMENT_ID                                                                               VARCHAR2(128)
 HOSTNAME_LABEL                                                                               VARCHAR2(16)
 AVAILABILITY_DOMAIN                                                                          VARCHAR2(32)


SELECT tcomp.NAME COMPARTMENT_NAME,
       tvcn.DISPLAY_NAME VCN_NAME,
       tsub.DISPLAY_NAME SUBNET_NAME,
       tpip.IP_ADDRESS,
       tpip.IS_PRIMARY,
       tpip.DISPLAY_NAME,
       tpip.TIME_CREATED,
       tpip.HOSTNAME_LABEL,
       tpip.AVAILABILITY_DOMAIN,
       tpip.VNIC_ID,
       tpip.ID
FROM   OCI360_PRIVATEIPS tpip,
       (select distinct id, vcn_id, display_name from OCI360_SUBNETS) tsub,
       OCI360_COMPARTMENTS tcomp,
       OCI360_VCNS tvcn
WHERE  substr(tpip.id,instr(tpip.id,'.',1,3)+1,instr(tpip.id,'.',1,4)-instr(tpip.id,'.',1,3)-1) = 'iad'
AND    tpip.COMPARTMENT_ID = tcomp.ID
AND    tpip.SUBNET_ID = tsub.id
AND    tsub.VCN_ID = tvcn.ID;


1 rows selected.