8b.605. Control - Json Columns (OCI360_JSONCOLS) 8b.605. Control - Json Columns (OCI360_JSONCOLS)
| # | SOURCE | JPATH | TYPE | NEW_COL_NAME |
|---|---|---|---|---|
| 1 | oci_bds_instance_details.json | $.data.nodes."attached-block-volumes"."volume-size-in-gbs" | number | NODES$ATTACHED_BLOCK_VOLUMES$VOLUME_SIZE_IN_GBS |
| 2 | oci_bv_backup.json.gz | $.data."compartment-id" | string | COMPARTMENT_ID |
| 3 | oci_bv_backup.json.gz | $.data."display-name" | string | DISPLAY_NAME |
| 4 | oci_bv_backup.json.gz | $.data."expiration-time" | string | EXPIRATION_TIME |
| 5 | oci_bv_backup.json.gz | $.data.id | string | ID |
| 6 | oci_bv_backup.json.gz | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 7 | oci_bv_backup.json.gz | $.data."size-in-gbs" | number | SIZE_IN_GBS |
| 8 | oci_bv_backup.json.gz | $.data."size-in-mbs" | number | SIZE_IN_MBS |
| 9 | oci_bv_backup.json.gz | $.data."source-type" | string | SOURCE_TYPE |
| 10 | oci_bv_backup.json.gz | $.data."source-volume-backup-id" | string | SOURCE_VOLUME_BACKUP_ID |
| 11 | oci_bv_backup.json.gz | $.data."time-created" | string | TIME_CREATED |
| 12 | oci_bv_backup.json.gz | $.data."time-request-received" | string | TIME_REQUEST_RECEIVED |
| 13 | oci_bv_backup.json.gz | $.data.type | string | TYPE |
| 14 | oci_bv_backup.json.gz | $.data."unique-size-in-gbs" | number | UNIQUE_SIZE_IN_GBS |
| 15 | oci_bv_backup.json.gz | $.data."unique-size-in-mbs" | number | UNIQUE_SIZE_IN_MBS |
| 16 | oci_bv_backup.json.gz | $.data."volume-id" | string | VOLUME_ID |
| 17 | oci_bv_boot-volume-backup.json | $.data."boot-volume-id" | string | BOOT_VOLUME_ID |
| 18 | oci_bv_boot-volume-backup.json | $.data."compartment-id" | string | COMPARTMENT_ID |
| 19 | oci_bv_boot-volume-backup.json | $.data."display-name" | string | DISPLAY_NAME |
| 20 | oci_bv_boot-volume-backup.json | $.data."expiration-time" | string | EXPIRATION_TIME |
| 21 | oci_bv_boot-volume-backup.json | $.data.id | string | ID |
| 22 | oci_bv_boot-volume-backup.json | $.data."image-id" | string | IMAGE_ID |
| 23 | oci_bv_boot-volume-backup.json | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 24 | oci_bv_boot-volume-backup.json | $.data."size-in-gbs" | number | SIZE_IN_GBS |
| 25 | oci_bv_boot-volume-backup.json | $.data."source-type" | string | SOURCE_TYPE |
| 26 | oci_bv_boot-volume-backup.json | $.data."time-created" | string | TIME_CREATED |
| 27 | oci_bv_boot-volume-backup.json | $.data."time-request-received" | string | TIME_REQUEST_RECEIVED |
| 28 | oci_bv_boot-volume-backup.json | $.data.type | string | TYPE |
| 29 | oci_bv_boot-volume-backup.json | $.data."unique-size-in-gbs" | number | UNIQUE_SIZE_IN_GBS |
| 30 | oci_bv_boot-volume.json.gz | $.data."source-details".id | string | SOURCE_DETAILS$ID |
| 31 | oci_bv_boot-volume.json.gz | $.data."source-details".type | string | SOURCE_DETAILS$TYPE |
| 32 | oci_bv_volume-backup-policy-assignment.json | $.data."asset-id" | string | ASSET_ID |
| 33 | oci_bv_volume-backup-policy-assignment.json | $.data.id | string | ID |
| 34 | oci_bv_volume-backup-policy-assignment.json | $.data."policy-id" | string | POLICY_ID |
| 35 | oci_bv_volume-backup-policy-assignment.json | $.data."time-created" | string | TIME_CREATED |
| 36 | oci_bv_volume.json.gz | $.data."availability-domain" | string | AVAILABILITY_DOMAIN |
| 37 | oci_bv_volume.json.gz | $.data."compartment-id" | string | COMPARTMENT_ID |
| 38 | oci_bv_volume.json.gz | $.data."display-name" | string | DISPLAY_NAME |
| 39 | oci_bv_volume.json.gz | $.data.id | string | ID |
| 40 | oci_bv_volume.json.gz | $.data."is-hydrated" | boolean | IS_HYDRATED |
| 41 | oci_bv_volume.json.gz | $.data."kms-key-id" | string | KMS_KEY_ID |
| 42 | oci_bv_volume.json.gz | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 43 | oci_bv_volume.json.gz | $.data."size-in-gbs" | number | SIZE_IN_GBS |
| 44 | oci_bv_volume.json.gz | $.data."size-in-mbs" | number | SIZE_IN_MBS |
| 45 | oci_bv_volume.json.gz | $.data."source-details".id | string | SOURCE_DETAILS$ID |
| 46 | oci_bv_volume.json.gz | $.data."source-details".type | string | SOURCE_DETAILS$TYPE |
| 47 | oci_bv_volume.json.gz | $.data."time-created" | string | TIME_CREATED |
| 48 | oci_bv_volume.json.gz | $.data."volume-group-id" | string | VOLUME_GROUP_ID |
| 49 | oci_bv_volume.json.gz | $.data."vpus-per-gb" | string | VPUS_PER_GB |
| 50 | oci_compute_volume-attachment.json.gz | $.data."attachment-type" | string | ATTACHMENT_TYPE |
| 51 | oci_compute_volume-attachment.json.gz | $.data."availability-domain" | string | AVAILABILITY_DOMAIN |
| 52 | oci_compute_volume-attachment.json.gz | $.data."compartment-id" | string | COMPARTMENT_ID |
| 53 | oci_compute_volume-attachment.json.gz | $.data."display-name" | string | DISPLAY_NAME |
| 54 | oci_compute_volume-attachment.json.gz | $.data.id | string | ID |
| 55 | oci_compute_volume-attachment.json.gz | $.data."instance-id" | string | INSTANCE_ID |
| 56 | oci_compute_volume-attachment.json.gz | $.data.ipv4 | string | IPV4 |
| 57 | oci_compute_volume-attachment.json.gz | $.data.iqn | string | IQN |
| 58 | oci_compute_volume-attachment.json.gz | $.data."is-pv-encryption-in-transit-enabled" | boolean | IS_PV_ENCRYPTION_IN_TRANSIT_ENABLED |
| 59 | oci_compute_volume-attachment.json.gz | $.data."is-read-only" | boolean | IS_READ_ONLY |
| 60 | oci_compute_volume-attachment.json.gz | $.data."is-shareable" | boolean | IS_SHAREABLE |
| 61 | oci_compute_volume-attachment.json.gz | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 62 | oci_compute_volume-attachment.json.gz | $.data.port | number | PORT |
| 63 | oci_compute_volume-attachment.json.gz | $.data."time-created" | string | TIME_CREATED |
| 64 | oci_compute_volume-attachment.json.gz | $.data."volume-id" | string | VOLUME_ID |
| 65 | oci_db_node.json | $.data.hostname | string | HOSTNAME |
| 66 | oci_db_node.json | $.data.id | string | ID |
| 67 | oci_db_node.json | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 68 | oci_db_node.json | $.data."software-storage-size-in-gb" | number | SOFTWARE_STORAGE_SIZE_IN_GB |
| 69 | oci_db_node.json | $.data."vnic-id" | string | VNIC_ID |
| 70 | oci_db_system.json | $.data."data-storage-size-in-gbs" | number | DATA_STORAGE_SIZE_IN_GBS |
| 71 | oci_db_system.json | $.data.id | string | ID |
| 72 | oci_db_system.json | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 73 | oci_db_system.json | $.data."reco-storage-size-in-gb" | number | RECO_STORAGE_SIZE_IN_GB |
| 74 | oci_network_drg-attachment.json | $.data."drg-id" | string | DRG_ID |
| 75 | oci_network_drg-attachment.json | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 76 | oci_network_drg-attachment.json | $.data."vcn-id" | string | VCN_ID |
| 77 | oci_network_local-peering-gateway.json.gz | $.data."compartment-id" | string | COMPARTMENT_ID |
| 78 | oci_network_local-peering-gateway.json.gz | $.data."display-name" | string | DISPLAY_NAME |
| 79 | oci_network_local-peering-gateway.json.gz | $.data.id | string | ID |
| 80 | oci_network_local-peering-gateway.json.gz | $.data."is-cross-tenancy-peering" | boolean | IS_CROSS_TENANCY_PEERING |
| 81 | oci_network_local-peering-gateway.json.gz | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 82 | oci_network_local-peering-gateway.json.gz | $.data."peer-advertised-cidr" | string | PEER_ADVERTISED_CIDR |
| 83 | oci_network_local-peering-gateway.json.gz | $.data."peering-status-details" | string | PEERING_STATUS_DETAILS |
| 84 | oci_network_local-peering-gateway.json.gz | $.data."peering-status" | string | PEERING_STATUS |
| 85 | oci_network_local-peering-gateway.json.gz | $.data."time-created" | string | TIME_CREATED |
| 86 | oci_network_local-peering-gateway.json.gz | $.data."vcn-id" | string | VCN_ID |
| 87 | oci_network_remote-peering-connection.json | $.data."compartment-id" | string | COMPARTMENT_ID |
| 88 | oci_network_remote-peering-connection.json | $.data."display-name" | string | DISPLAY_NAME |
| 89 | oci_network_remote-peering-connection.json | $.data."drg-id" | string | DRG_ID |
| 90 | oci_network_remote-peering-connection.json | $.data.id | string | ID |
| 91 | oci_network_remote-peering-connection.json | $.data."is-cross-tenancy-peering" | boolean | IS_CROSS_TENANCY_PEERING |
| 92 | oci_network_remote-peering-connection.json | $.data."lifecycle-state" | string | LIFECYCLE_STATE |
| 93 | oci_network_remote-peering-connection.json | $.data."peer-id" | string | PEER_ID |
| 94 | oci_network_remote-peering-connection.json | $.data."peering-status" | string | PEERING_STATUS |
| 95 | oci_network_remote-peering-connection.json | $.data."peer-region-name" | string | PEER_REGION_NAME |
| 96 | oci_network_remote-peering-connection.json | $.data."peer-tenancy-id" | string | PEER_TENANCY_ID |
| 97 | oci_network_remote-peering-connection.json | $.data."time-created" | string | TIME_CREATED |
| 98 | oci_network_security-list.json.gz | $.data."egress-security-rules".destination | string | EGRESS_SECURITY_RULES$DESTINATION |
| 99 | oci_network_security-list.json.gz | $.data."egress-security-rules"."destination-type" | string | EGRESS_SECURITY_RULES$DESTINATION_TYPE |
| 100 | oci_network_security-list.json.gz | $.data."egress-security-rules"."icmp-options".code | string | EGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE |
| 101 | oci_network_security-list.json.gz | $.data."egress-security-rules"."icmp-options".type | number | EGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE |
| 102 | oci_network_security-list.json.gz | $.data."egress-security-rules"."is-stateless" | string | EGRESS_SECURITY_RULES$IS_STATELESS |
| 103 | oci_network_security-list.json.gz | $.data."egress-security-rules".protocol | string | EGRESS_SECURITY_RULES$PROTOCOL |
| 104 | oci_network_security-list.json.gz | $.data."egress-security-rules"."tcp-options"."destination-port-range".max | number | EGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MAX |
| 105 | oci_network_security-list.json.gz | $.data."egress-security-rules"."tcp-options"."destination-port-range".min | number | EGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MIN |
| 106 | oci_network_security-list.json.gz | $.data."egress-security-rules"."tcp-options"."source-port-range".max | number | EGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MAX |
| 107 | oci_network_security-list.json.gz | $.data."egress-security-rules"."tcp-options"."source-port-range".min | number | EGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MIN |
| 108 | oci_network_security-list.json.gz | $.data."egress-security-rules"."udp-options"."destination-port-range".max | number | EGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MAX |
| 109 | oci_network_security-list.json.gz | $.data."egress-security-rules"."udp-options"."destination-port-range".min | number | EGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MIN |
| 110 | oci_network_security-list.json.gz | $.data."egress-security-rules"."udp-options"."source-port-range".max | number | EGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MAX |
| 111 | oci_network_security-list.json.gz | $.data."egress-security-rules"."udp-options"."source-port-range".min | number | EGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MIN |
| 112 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."icmp-options".code | string | INGRESS_SECURITY_RULES$ICMP_OPTIONS$CODE |
| 113 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."icmp-options".type | number | INGRESS_SECURITY_RULES$ICMP_OPTIONS$TYPE |
| 114 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."is-stateless" | string | INGRESS_SECURITY_RULES$IS_STATELESS |
| 115 | oci_network_security-list.json.gz | $.data."ingress-security-rules".protocol | string | INGRESS_SECURITY_RULES$PROTOCOL |
| 116 | oci_network_security-list.json.gz | $.data."ingress-security-rules".source | string | INGRESS_SECURITY_RULES$SOURCE |
| 117 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."source-type" | string | INGRESS_SECURITY_RULES$SOURCE_TYPE |
| 118 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."tcp-options"."destination-port-range".max | number | INGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MAX |
| 119 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."tcp-options"."destination-port-range".min | number | INGRESS_SECURITY_RULES$TCP_OPTIONS$DESTINATION_PORT_RANGE$MIN |
| 120 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."tcp-options"."source-port-range".max | number | INGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MAX |
| 121 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."tcp-options"."source-port-range".min | number | INGRESS_SECURITY_RULES$TCP_OPTIONS$SOURCE_PORT_RANGE$MIN |
| 122 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."udp-options"."destination-port-range".max | number | INGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MAX |
| 123 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."udp-options"."destination-port-range".min | number | INGRESS_SECURITY_RULES$UDP_OPTIONS$DESTINATION_PORT_RANGE$MIN |
| 124 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."udp-options"."source-port-range".max | number | INGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MAX |
| 125 | oci_network_security-list.json.gz | $.data."ingress-security-rules"."udp-options"."source-port-range".min | number | INGRESS_SECURITY_RULES$UDP_OPTIONS$SOURCE_PORT_RANGE$MIN |
#: click on a column heading to sort on it
Name Null? Type
----------------------------------------------------------------------------------- -------- --------------------------------------------------------
SOURCE NOT NULL VARCHAR2(100)
JPATH NOT NULL VARCHAR2(200)
TYPE VARCHAR2(10)
NEW_COL_NAME VARCHAR2(100)
SELECT t1.*
FROM "OCI360_JSONCOLS" t1;
125 rows selected.