[GitHub] [calcite] danny0405 commented on a change in pull request #1866: [CALCITE-3726] Documentation for Declaring Objects For Types Defined …

[GitBox <gi...@apache.org>]

danny0405 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_r396173331
 
 

 ##########
 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:
   Also give DDL that define employee_typ and address_typ.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services