3a.1.90. NAT Gateways (OCI360_NAT_GATEWAYS) 3a.1.90. NAT Gateways (OCI360_NAT_GATEWAYS)
| # | ID | NAT_IP | VCN_ID | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | TIME_CREATED | BLOCK_TR | FREEFORM_TAGS$VCN | COMPARTMENT_ID | LIFECYCLE_STATE |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000587 | 150.136.X.X | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | oracleidentitycloudservice/[email protected] | 2020-04-28T22:28:11.197Z | ng_vcn_dev | 2020-04-28T22:28:11.436000+00:00 | false | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | |
| 2 | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000588 | 150.136.X.X | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | oracleidentitycloudservice/[email protected] | 2020-04-28T22:27:42.745Z | ng_vcn_hml | 2020-04-28T22:27:42.885000+00:00 | false | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | |
| 3 | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000586 | 150.136.X.X | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | oracleidentitycloudservice/[email protected] | 2020-04-24T22:06:36.790Z | ng_vcn_prd | 2020-04-24T22:06:36.988000+00:00 | false | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | |
| 4 | ocid1.natgateway.oc1.iad.000000000000000000000000000000000000000000000000000000000585 | 150.136.X.X | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000696 | oracleidentitycloudservice/[email protected] | 2020-04-18T22:34:42.947Z | NAT Gateway-vcn_test | 2020-04-18T22:34:43.107000+00:00 | false | VCN-2020-04-18T22:34:13 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | AVAILABLE |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
NAT_IP VARCHAR2(16)
VCN_ID VARCHAR2(128)
DEFINED_TAGS$ORACLE_TAGS$CREATEDBY VARCHAR2(64)
DEFINED_TAGS$ORACLE_TAGS$CREATEDON VARCHAR2(32)
DISPLAY_NAME VARCHAR2(32)
TIME_CREATED VARCHAR2(32)
BLOCK_TRAFFIC VARCHAR2(8)
FREEFORM_TAGS$VCN VARCHAR2(32)
COMPARTMENT_ID VARCHAR2(128)
LIFECYCLE_STATE VARCHAR2(16)
SELECT t1.*
FROM OCI360_NAT_GATEWAYS t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
4 rows selected.