3a.1.98. VCNs (OCI360_VCNS) 3a.1.98. VCNs (OCI360_VCNS)
| # | ID | DNS_LABE | CIDR_BLOCK | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | TIME_CREATED | FREEFORM_TAGS$VCN | COMPARTMENT_ID | IPV6 | LIFECYCLE_STATE | VCN_DOMAIN_NAME | DEFAULT_ROUTE_TABLE_ID | IPV6 | DEFAULT_DHCP_OPTIONS_ID | DEFAULT_SECURITY_LIST_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000697 | vcn | 10.0.0.0/16 | oracleidentitycloudservice/[email protected] | 2020-04-28T22:46:27.217Z | vcn-20200428-1946 | 2020-04-28T22:46:27.221000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | AVAILABLE | vcn.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000636 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000241 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000647 | |||
| 2 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000695 | vcnss | 10.100.16.0/22 | oracleidentitycloudservice/[email protected] | 2020-04-24T20:24:12.234Z | vcn_ss | 2020-04-24T20:24:12.262000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | vcnss.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000633 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000233 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000649 | |||
| 3 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | vcnhml | 10.100.12.0/22 | oracleidentitycloudservice/[email protected] | 2020-04-24T20:22:43.250Z | vcn_hml | 2020-04-24T20:22:43.254000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | vcnhml.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000637 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000235 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000653 | |||
| 4 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | vcndev | 10.100.4.0/22 | oracleidentitycloudservice/[email protected] | 2020-04-24T20:22:04.146Z | vcn_dev | 2020-04-24T20:22:04.149000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | vcndev.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000626 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000247 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000661 | |||
| 5 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000692 | vcnhub | 10.100.0.0/22 | oracleidentitycloudservice/[email protected] | 2020-04-24T20:21:45.907Z | vcn_hub | 2020-04-24T20:21:45.910000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | vcnhub.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000638 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000239 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000654 | |||
| 6 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | vcnprd | 10.100.8.0/22 | oracleidentitycloudservice/[email protected] | 2020-04-24T20:22:24.293Z | vcn_prd | 2020-04-24T20:22:24.296000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000219 | AVAILABLE | vcnprd.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000630 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000243 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000651 | |||
| 7 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000696 | vcntest | 10.0.0.0/16 | oracleidentitycloudservice/[email protected] | 2020-04-18T22:34:41.376Z | vcn_test | 2020-04-18T22:34:41.379000+00:00 | VCN-2020-04-18T22:34:13 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | AVAILABLE | vcntest.oraclevcn.com | ocid1.routetable.oc1.iad.000000000000000000000000000000000000000000000000000000000629 | ocid1.dhcpoptions.oc1.iad.000000000000000000000000000000000000000000000000000000000244 | ocid1.securitylist.oc1.iad.000000000000000000000000000000000000000000000000000000000652 |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
DNS_LABEL VARCHAR2(8)
CIDR_BLOCK VARCHAR2(16)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(32)
TIME_CREATED VARCHAR2(32)
FREEFORM_TAGS$VCN VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
IPV6_CIDR_BLOCK VARCHAR2(4)
LIFECYCLE_STATE VARCHAR2(16)
VCN_DOMAIN_NAME VARCHAR2(32)
DEFAULT_ROUTE_TABLE_ID VARCHAR2(128)
IPV6_PUBLIC_CIDR_BLOCK VARCHAR2(4)
DEFAULT_DHCP_OPTIONS_ID VARCHAR2(128)
DEFAULT_SECURITY_LIST_ID VARCHAR2(128)
SELECT t1.*
FROM OCI360_VCNS t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
7 rows selected.