- DEFAULT NULL
- DEFAULT value
If you specify DEFAULT value, you can use a JSON constructor expression to initialize the local variable. See About JSON Type Constructor.
You can use the stored procedure semantics, including cursors, to access a particular value, name/value pair, or nested documents structured as objects or arrays. You can use this with the JSON methods and functions that allow JSONPath request syntax for access to specific portions of a JSON instance.