ritesh-kapoor commented on a change in pull request #1866: [CALCITE-3726] Documentation for Declaring Objects For Types Defined … URL: https://github.com/apache/calcite/pull/1866#discussion_r399001957
########## File path: site/_docs/reference.md ########## @@ -2286,6 +2286,17 @@ Note: * If `ORDER BY` clause is provided, `JSON_ARRAYAGG` sorts the input rows into the specified order before performing aggregation. + +#### Declaring Objects For Types Defined In Schema +After an object type is defined and installed in the schema, you can use it to declare objects in any SQL block. For example, you can use the object type to specify the datatype of an attribute, column, variable, bind variable, record field, table element, formal parameter, or function result. At run time, instances of the object type are created; that is, objects of that type are instantiated. Each object can hold different values. + +e.g.: +```SQL +employee_typ(315, 'Francis', 'Logan', 'FLOGAN', + '555.777.2222', '01-MAY-04', 'SA_MAN', 11000, .15, 101, 110, Review comment: Updated documentation :) ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services