oci360 6a.580. Database Systems Scan IDs (OCI360_DB_SYSTEMS)


WHERE  SCAN_IP_IDS is not null
       *
ERROR at line 7:
ORA-00904: "SCAN_IP_IDS": invalid identifier
#: click on a column heading to sort on it
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 DATA_STORAGE_SIZE_IN_GBS                                                                     NUMBER(1)
 LIFECYCLE_STATE                                                                              VARCHAR2(1)
 RECO_STORAGE_SIZE_IN_GB                                                                      NUMBER(1)
 ID                                                                                           VARCHAR2(1)


SELECT ID,
       CLUSTER_NAME,
       DISPLAY_NAME,
       SCAN_IP_IDS
FROM   OCI360_DB_SYSTEMS t1
WHERE  SCAN_IP_IDS is not null;


-1 rows selected.

oci360 (c) 2020, All rights reserved. oci360 v20.06 (2020-06-25) based on moat369 v2002 (2020-02-27). Timestamp: 2020-06-30T16:48:14