3a.1.96. Network Services (OCI360_NETSERVICES)

#	ID	NAME	CIDR_BLOCK	DESCRIPTION
1	ocid1.service.oc1.iad.000000000000000000000000000000000000000000000000000000000662	OCI IAD Object Storage	oci-iad-objectstorage	OCI IAD Object Storage
2	ocid1.service.oc1.iad.000000000000000000000000000000000000000000000000000000000663	All IAD Services In Oracle Services Network	all-iad-services-in-oracle-services-network	All IAD Services In Oracle Services Network

#: click on a column heading to sort on it

 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 ID                                                                                           VARCHAR2(128)
 NAME                                                                                         VARCHAR2(64)
 CIDR_BLOCK                                                                                   VARCHAR2(64)
 DESCRIPTION                                                                                  VARCHAR2(64)


SELECT t1.*
FROM   OCI360_NETSERVICES t1
WHERE  substr(id,instr(id,'.',1,3)+1,instr(id,'.',1,4)-instr(id,'.',1,3)-1) = 'iad';


2 rows selected.