6a.592. Database Networks (OCI360_DB_SYSTEMS)

FROM   (select distinct id, cluster_name, display_name, hostname, time_created, lifecycle_state, shape FROM OCI360_DB_SYSTEMS) t1,
                                                                                                 *

ERROR at line 12:
ORA-00904: "SHAPE": 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 t1.CLUSTER_NAME,
       t1.DISPLAY_NAME,
       t1.hostname SYSTEM_HOSTNAME,
       t1.TIME_CREATED,
       t1.LIFECYCLE_STATE SYSTEM_LIFECYCLE_STATE,
       t1.SHAPE,
       'BACKUP' IP_TYPE,
       t3.ip_address,
       t2.hostname NODE_HOSTNAME,
       t2.LIFECYCLE_STATE NODE_LIFECYCLE_STATE
FROM   (select distinct id, cluster_name, display_name, hostname, time_created, lifecycle_state, shape FROM OCI360_DB_SYSTEMS) t1,
       OCI360_DB_NODES t2,
       OCI360_PRIVATEIPS t3
where  t1.id=t2.DB_SYSTEM_ID
and    t2.BACKUP_VNIC_ID = t3.VNIC_ID
and    t3.IS_PRIMARY='true'
UNION ALL
SELECT t1.CLUSTER_NAME,
       t1.DISPLAY_NAME,
       t1.hostname SYSTEM_HOSTNAME,
       t1.TIME_CREATED,
       t1.LIFECYCLE_STATE SYSTEM_LIFECYCLE_STATE,
       t1.SHAPE,
       'PUBLIC' IP_TYPE,
       t3.ip_address,
       t2.hostname NODE_HOSTNAME,
       t2.LIFECYCLE_STATE NODE_LIFECYCLE_STATE
FROM   (select distinct id, cluster_name, display_name, hostname, time_created, lifecycle_state, shape FROM OCI360_DB_SYSTEMS) t1,
       OCI360_DB_NODES t2,
       OCI360_PRIVATEIPS t3
where  t1.id=t2.DB_SYSTEM_ID
and    t2.VNIC_ID=t3.VNIC_ID
and    t3.IS_PRIMARY='true'
UNION ALL
SELECT t1.CLUSTER_NAME,
       t1.DISPLAY_NAME,
       t1.hostname SYSTEM_HOSTNAME,
       t1.TIME_CREATED,
       t1.LIFECYCLE_STATE SYSTEM_LIFECYCLE_STATE,
       t1.SHAPE,
       'VIP' IP_TYPE,
       t3.ip_address,
       t2.hostname NODE_HOSTNAME,
       t2.LIFECYCLE_STATE NODE_LIFECYCLE_STATE
FROM   (select distinct id, vip_ids, cluster_name, display_name, hostname, time_created, lifecycle_state, shape FROM OCI360_DB_SYSTEMS) t1,
       OCI360_DB_NODES t2,
       OCI360_PRIVATEIPS t3
where  t1.id=t2.DB_SYSTEM_ID
and    t2.VNIC_ID=t3.VNIC_ID
and    t1.vip_ids like '%' || t3.ID || '%'
UNION ALL
SELECT t1.CLUSTER_NAME,
       t1.DISPLAY_NAME,
       t1.hostname SYSTEM_HOSTNAME,
       t1.TIME_CREATED,
       t1.LIFECYCLE_STATE SYSTEM_LIFECYCLE_STATE,
       t1.SHAPE,
       'SCAN'    IP_TYPE,
       t3.ip_address,
       t2.hostname NODE_HOSTNAME,
       t2.LIFECYCLE_STATE NODE_LIFECYCLE_STATE
FROM   (select distinct id, scan_ip_ids, cluster_name, display_name, hostname, time_created, lifecycle_state, shape FROM OCI360_DB_SYSTEMS) t1,
       OCI360_DB_NODES t2,
       OCI360_PRIVATEIPS t3
where  t1.id=t2.DB_SYSTEM_ID
and    t2.VNIC_ID=t3.VNIC_ID
and    t1.scan_ip_ids like '%' || t3.ID || '%'
ORDER BY CLUSTER_NAME,IP_TYPE,NODE_HOSTNAME;


-1 rows selected.