# Run this as sys! 

create user shop identified by welcome1; 
grant connect, resource, unlimited tablespace to shop; 

create sequence shop.seq_products; 
create table shop.products 
 (prod_nr number default shop.seq_products.nextval, 
  name    varchar2(100), 
  note    varchar2(200)); 



insert into shop.products (name,note) values ('Glen Spirit 10y','Standard'); 
insert into shop.products (name,note) values ('Glen Spirit 15y','Rare'); 
insert into shop.products (name,note) values ('Glen Spirit 12y Cask Strength','Rich flavor'); 
insert into shop.products (name,note) values ('Glen Spirit 18y Single Cask','Special Selected Casks'); 
commit; 

alter table shop.products add more_info_link varchar2(400); 
update shop.products set more_info_link='http://www.oracle.com'; 
commit; 
