Previous Next JavaScript must be enabled to correctly display this content

## Using Map Steps with JSON Data

On import, Oracle NoSQL Database stores JSON objects as MAP(JSON). This means you can use map filter steps with your JSON objects.

For example, if you want to visually examine the JSON fields in use by your rows:

    sql-> SELECT id, j.person.keys() FROM JSONPersons j;
     +----+------------------------+
     | id |        Column_2        |
     +----+------------------------+
     |  4 | address                |
     |    | age                    |
     |    | connections            |
     |    | expenses               |
     |    | firstname              |
     |    | income                 |
     |    | lastLogin              |
     |    | lastname               |
     +----+------------------------+
     |  6 | myarray                |
     |    | mynumber               |
     +----+------------------------+
     |  3 | address                |
     |    | age                    |
     |    | connections            |
     |    | expenses               |
     |    | firstname              |
     |    | income                 |
     |    | lastLogin              |
     |    | lastname               |
     +----+------------------------+
     |  5 | address                |
     |    | age                    |
     |    | connections            |
     |    | expenses               |
     |    | firstname              |
     |    | income                 |
     |    | lastLogin              |
     |    | lastname               |
     +----+------------------------+
     |  1 | address                |
     |    | age                    |
     |    | connections            |
     |    | expenses               |
     |    | firstname              |
     |    | income                 |
     |    | lastLogin              |
     |    | lastname               |
     +----+------------------------+
     |  7 | myarray                |
     |    | mynumber               |
     +----+------------------------+
     |  2 | address                |
     |    | age                    |
     |    | connections            |
     |    | expenses               |
     |    | firstname              |
     |    | income                 |
     |    | lastLogin              |
     |    | lastname               |
     +----+------------------------+

    7 rows returned