@HIDDEN Directive
The @hidden GraphQL directive in Oracle is used to hide a
JSON field in the output. This directive is used only for duality-view creation and not
supported in the table function.
The directive
@hidden takes no arguments. See Generated Fields, Hidden Fields.
Note:
A field defined asflex cannot be hidden.
SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
race {
id: race_id
name @hidden
}
');The above example hides the field
name from the output and would produce
which only contains the
race_id:DATA
--------------------------------------------------------------------------------
{
"id" : 201,
}
{
"id" : 202,
}
{
"id" : 203,
}
{
"id" : 204,
}
.......................
.......................
24 rows selected.