Difference between revisions of "Plsql variables"
From John Freier
(Created page with ' DECLARE attrId number; BEGIN attId:= seq_attr.nextval; dbms_output.put_line (attId); END;') |
|||
| Line 1: | Line 1: | ||
| + | When declaring variables you must also specify the block where the variables are going to be used. | ||
| + | |||
| + | * attrId = Variable name | ||
| + | * ':=' = Sets the variable to a value | ||
| + | |||
DECLARE | DECLARE | ||
attrId number; | attrId number; | ||
Revision as of 13:59, 17 December 2012
When declaring variables you must also specify the block where the variables are going to be used.
- attrId = Variable name
- ':=' = Sets the variable to a value
DECLARE
attrId number;
BEGIN
attId:= seq_attr.nextval;
dbms_output.put_line (attId);
END;
