6a.578. Database Systems (OCI360_DB_SYSTEMS)

       LAST_PATCH_HISTORY_ENTRY_ID
       *

ERROR at line 28:
ORA-00904: "LAST_PATCH_HISTORY_ENTRY_ID": 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 distinct
       ID,
       SHAPE,
       DOMAIN,
       VERSION,
       HOSTNAME,
       SUBNET_ID,
       NODE_COUNT,
       CLUSTER_NAME,
       DISPLAY_NAME,
       TIME_CREATED,
       LICENSE_MODEL,
       LISTENER_PORT,
       COMPARTMENT_ID,
       CPU_CORE_COUNT,
       DISK_REDUNDANCY,
       LIFECYCLE_STATE,
       BACKUP_SUBNET_ID,
       DATABASE_EDITION,
       SPARSE_DISKGROUP,
       LIFECYCLE_DETAILS,
       SCAN_DNS_RECORD_ID,
       AVAILABILITY_DOMAIN,
       DATA_STORAGE_PERCENTAGE,
       RECO_STORAGE_SIZE_IN_GB,
       DATA_STORAGE_SIZE_IN_GBS,
       LAST_PATCH_HISTORY_ENTRY_ID
FROM   OCI360_DB_SYSTEMS t1;


-1 rows selected.