Plsql variables

From John Freier
Revision as of 13:59, 17 December 2012 by Jfreier (Talk | contribs)

Jump to: navigation, search

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;