You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Danny Chen (Jira)" <ji...@apache.org> on 2020/03/18 02:20:00 UTC
[jira] [Updated] (CALCITE-3726) Allow declaring type objects
[ https://issues.apache.org/jira/browse/CALCITE-3726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Danny Chen updated CALCITE-3726:
--------------------------------
Description:
[https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/objects.htm#i7530]
e.g. :
{code:java}
employee_typ(315, 'Francis', 'Logan', 'FLOGAN',
'555.777.2222', '01-MAY-04', 'SA_MAN', 11000, .15, 101, 110,
address_typ('376 Mission', 'San Francisco', 'CA', '94222'))
{code}
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.
Such objects follow the usual scope and instantiation rules. In a block or subprogram, local objects are instantiated when you enter the block or subprogram and cease to exist when you exit. In a package, objects are instantiated when you first reference the package and cease to exist when you end the database session.
was:
[https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/objects.htm#i7530]
e.g. :
{code:java}
employee_typ(315, 'Francis', 'Logan', 'FLOGAN',
'555.777.2222', '01-MAY-04', 'SA_MAN', 11000, .15, 101, 110,
address_typ('376 Mission', 'San Francisco', 'CA', '94222'))
{code}
> Allow declaring type objects
> ----------------------------
>
> Key: CALCITE-3726
> URL: https://issues.apache.org/jira/browse/CALCITE-3726
> Project: Calcite
> Issue Type: New Feature
> Reporter: Ritesh
> Assignee: Ritesh
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.23.0
>
> Time Spent: 5h 40m
> Remaining Estimate: 0h
>
> [https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/objects.htm#i7530]
> e.g. :
>
> {code:java}
> employee_typ(315, 'Francis', 'Logan', 'FLOGAN',
> '555.777.2222', '01-MAY-04', 'SA_MAN', 11000, .15, 101, 110,
> address_typ('376 Mission', 'San Francisco', 'CA', '94222'))
> {code}
> 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.
> Such objects follow the usual scope and instantiation rules. In a block or subprogram, local objects are instantiated when you enter the block or subprogram and cease to exist when you exit. In a package, objects are instantiated when you first reference the package and cease to exist when you end the database session.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)