3a.1.97. Network Service Gateways (OCI360_NETSERVICE_GW) 3a.1.97. Network Service Gateways (OCI360_NETSERVICE_GW)
| # | ID | VCN_ID | DEFINED_TAGS$ORACLE_TAGS$CREATEDBY | DEFINED_TAGS$ORACLE_TAGS$CREATED | DISPLAY_NAME | TIME_CREATED | BLOCK_TR | FREEFORM_TAGS$VCN | COMPARTMENT_ID | ROUT | LIFECYCLE_STATE | SERVICES$SERVICE_ID | SERVICES$SERVICE_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ocid1.servicegateway.oc1.iad.000000000000000000000000000000000000000000000000000000000666 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000694 | oracleidentitycloudservice/[email protected] | 2020-04-28T22:28:22.639Z | sg_vcn_dev | 2020-04-28T22:28:23.275000+00:00 | false | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | ocid1.service.oc1.iad.000000000000000000000000000000000000000000000000000000000663 | All IAD Services In Oracle Services Network | ||
| 2 | ocid1.servicegateway.oc1.iad.000000000000000000000000000000000000000000000000000000000664 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000693 | oracleidentitycloudservice/[email protected] | 2020-04-28T22:27:33.299Z | sg_vcn_hml | 2020-04-28T22:27:33.749000+00:00 | false | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | ocid1.service.oc1.iad.000000000000000000000000000000000000000000000000000000000663 | All IAD Services In Oracle Services Network | ||
| 3 | ocid1.servicegateway.oc1.iad.000000000000000000000000000000000000000000000000000000000665 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000698 | oracleidentitycloudservice/[email protected] | 2020-04-24T22:06:56.760Z | sg_vcn_prd | 2020-04-24T22:06:57.206000+00:00 | false | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000214 | AVAILABLE | ocid1.service.oc1.iad.000000000000000000000000000000000000000000000000000000000663 | All IAD Services In Oracle Services Network | ||
| 4 | ocid1.servicegateway.oc1.iad.000000000000000000000000000000000000000000000000000000000667 | ocid1.vcn.oc1.iad.000000000000000000000000000000000000000000000000000000000696 | oracleidentitycloudservice/[email protected] | 2020-04-18T22:34:42.655Z | Service Gateway-vcn_test | 2020-04-18T22:34:43.289000+00:00 | false | VCN-2020-04-18T22:34:13 | ocid1.compartment.oc1..000000000000000000000000000000000000000000000000000000000227 | AVAILABLE | ocid1.service.oc1.iad.000000000000000000000000000000000000000000000000000000000663 | All IAD Services In Oracle Services Network |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
ID VARCHAR2(128)
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)
ROUTE_TABLE_ID VARCHAR2(4)
LIFECYCLE_STATE VARCHAR2(16)
SERVICES$SERVICE_ID VARCHAR2(128)
SERVICES$SERVICE_NAME VARCHAR2(64)
SELECT t1.*
FROM OCI360_NETSERVICE_GW t1
WHERE substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';
4 rows selected.