Create or Replace Table CUSTADRP (
   custno numeric(4, 0),
   name   char(30),
   street char(30),
   city   char(20),
   state  char(2),
   postal char(10),
   primary key(custno)
)
rcdfmt custadrf;

insert into CUSTADRP values
( 1000, 'Profound Logic Software',
        '396 Congress Park Dr',
        'Dayton', 'OH', '45459' ),
( 1234, 'ACME Inc',
        '123 Sesame Street',
        'New York', 'NY', '12345-4321'),
( 2000, 'Industrial Supply Ltd',
        '500 Main Street',
        'Anywhere', 'CA', '98765')