3a.1.83. VNICs (OCI360_VNICS)

#	COMPARTMENT_NAME	VCN_NAME	SUBNET_NAME	PUBLIC_IP	IS_P	PRIVATE_IP	MAC_ADDRESS	DISPLAY_NAME	TIME_CREATED	HOSTNAME_LABEL	LIFECYCLE_STATE	AVAILABILITY_DOMAIN	SKIP_SOU	ID
1	compt_ss_net	vcn_dev	subnet_dev_dmz	150.136.X.X	true	10.100.4.2	00:00:17:02:C5:6B	oci360comp	2020-05-20T14:54:11.550000+00:00	oci360comp	AVAILABLE	CYtq:US-ASHBURN-AD-3	false	ocid1.vnic.oc1.iad.000000000000000000000000000000000000000000000000000000000706

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 NSG_IDS                                                                                      VARCHAR2(4000)
 PUBLIC_IP                                                                                    VARCHAR2(16)
 SUBNET_ID                                                                                    VARCHAR2(128)
 IS_PRIMARY                                                                                   VARCHAR2(4)
 PRIVATE_IP                                                                                   VARCHAR2(16)
 MAC_ADDRESS                                                                                  VARCHAR2(32)
 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)
 LIFECYCLE_STATE                                                                              VARCHAR2(16)
 AVAILABILITY_DOMAIN                                                                          VARCHAR2(32)
 SKIP_SOURCE_DEST_CHECK                                                                       VARCHAR2(8)
 OCI360_TMP_DBARJ_CLOB$etag                                                                   VARCHAR2(8)


SELECT tcomp.NAME COMPARTMENT_NAME,
       tvcn.DISPLAY_NAME VCN_NAME,
       tsub.DISPLAY_NAME SUBNET_NAME,
       tvnic.public_ip,
       tvnic.is_primary,
       tvnic.private_ip,
       tvnic.mac_address,
       tvnic.display_name,
       tvnic.time_created,
       tvnic.hostname_label,
       tvnic.lifecycle_state,
       tvnic.availability_domain,
       tvnic.skip_source_dest_check,
       tvnic.id
FROM   OCI360_VNICS tvnic,
       (select distinct id, vcn_id, display_name from OCI360_SUBNETS) tsub,
       OCI360_COMPARTMENTS tcomp,
       OCI360_VCNS tvcn
WHERE  substr(tvnic.id,instr(tvnic.id,'.',1,3)+1,instr(tvnic.id,'.',1,4)-instr(tvnic.id,'.',1,3)-1) = 'iad'
AND    tvnic.COMPARTMENT_ID = tcomp.ID
AND    tvnic.SUBNET_ID = tsub.id
AND    tsub.VCN_ID = tvcn.ID;


1 rows selected.