3a.1.89. Internet Gateways (OCI360_INTERNET_GW) 3a.1.89. Internet Gateways (OCI360_INTERNET_GW)
| # | ID | VCN_ID | IS_E | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | TIME_CREATED | FREEFORM_TAGS$VCN | COMPARTMENT_ID | LIFECYCLE_STATE |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.internetgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000580 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000692 | true | oracleidentitycloudservice/[email protected] | 2020-04-24T20:50:47.092Z | ig_vcn_hub | 2020-04-24T20:50:47.106000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | |
| 2 | ocid1.internetgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000577 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | true | oracleidentitycloudservice/[email protected] | 2020-04-28T22:27:22.230Z | ig_vcn_hml | 2020-04-28T22:27:22.245000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | |
| 3 | ocid1.internetgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000576 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | true | oracleidentitycloudservice/[email protected] | 2020-04-28T22:28:05.303Z | ig_vcn_dev | 2020-04-28T22:28:05.320000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | |
| 4 | ocid1.internetgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000581 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000696 | true | oracleidentitycloudservice/[email protected] | 2020-04-18T22:34:42.513Z | Internet Gateway-vcn_test | 2020-04-18T22:34:42.538000+00:00 | VCN-2020-04-18T22:34:13 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | AVAILABLE |
| 5 | ocid1.internetgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000579 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000697 | true | oracleidentitycloudservice/[email protected] | 2020-04-28T22:46:28.413Z | Internet Gateway vcn-20200428-1946 | 2020-04-28T22:46:28.431000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000210 | AVAILABLE | |
| 6 | ocid1.internetgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000578 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | true | oracleidentitycloudservice/[email protected] | 2020-04-24T22:06:45.823Z | ig_vcn_prd | 2020-04-24T22:06:45.835000+00:00 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
VCN_ID VARCHAR2(128)
IS_ENABLED VARCHAR2(4)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(64)
TIME_CREATED VARCHAR2(32)
FREEFORM_TAGS$VCN VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
LIFECYCLE_STATE VARCHAR2(16)
SELECT t1.*
FROM OCI360_INTERNET_GW t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
6 rows selected.