Help for this page

Select Code to Download


  1. or download this
     Name                            Null?    Type
 ------------------------------- -------- ----
...
 REWARD_QUANTITY                 NOT NULL VARCHAR2(12)
 USES_PERCUSTOMER                NOT NULL NUMBER(5)
 USES_MAXIMUM                    NOT NULL NUMBER(10)
  2. or download this
    insert into Promotions
 (ID,Date_Created,Date_Modified,Title,
...
values
 (1,SYSDATE,SYSDATE,'test promotion',
  'phrase here',NULL,NULL,0,0,'','',0,'','',1,0);