This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
plsql [2015/10/26 12:47] dmtolpeko [Data Types and Declarations] |
plsql [2015/10/27 11:21] (current) dmtolpeko [Statements] |
||
---|---|---|---|
Line 14: | Line 14: | ||
| := or DEFAULT | Default clause | {{:green_tick.gif}} | 0.1 | | | := or DEFAULT | Default clause | {{:green_tick.gif}} | 0.1 | | ||
| [[type-attribute|%TYPE]] | Data type attribute | {{:green_tick.gif}} | 0.3.13 | | | [[type-attribute|%TYPE]] | Data type attribute | {{:green_tick.gif}} | 0.3.13 | | ||
+ | | SUBTYPE //subtype// IS //type// | Subtype | {{:red_cross.png}} || | ||
===== Data Types and Declarations ===== | ===== Data Types and Declarations ===== | ||
Line 67: | Line 68: | ||
| [[assign|:=]] | Assignment statement | {{:green_tick.gif}} | 0.1 | | | [[assign|:=]] | Assignment statement | {{:green_tick.gif}} | 0.1 | | ||
+ | | [[create-function|CREATE FUNCTION]] | Create a user-defined function | {{:green_tick.gif}} | 0.3.1 | | ||
+ | | [[create-package|CREATE PACKAGE]] | Create a package | {{:green_tick.gif}} | 0.3.13 | | ||
+ | | [[create-procedure|CREATE PROCEDURE]] | Create a stored procedure | {{:green_tick.gif}} | 0.3.1 | | ||
| [[null|NULL]] | No operation | {{:green_tick.gif}} | 0.3.13 | | | [[null|NULL]] | No operation | {{:green_tick.gif}} | 0.3.13 | | ||
- | | [[select-into|SELECT INTO]] | Assign values from query | {{:green_tick.gif}} | 0.1 | | + | | [[select-into|SELECT INTO]] | Assign values from query | {{:green_tick.gif}} | 0.1 | |