1-Tables.txt

SQL Workshop
Object Browser
Create
Table
Create Table 


create table "PRODUCT" (
    "PRODUCTID"   number NOT NULL,
    "PRODUCTNAME" varchar2(100),
    "SALESPRICE"  float,
    constraint  "PRODUCT_PK" primary key ("PRODUCTID")
)
/

create sequence "PRODUCT_SEQ" 
/

create trigger "BI_PRODUCT"  
  before insert on "PRODUCT"              
  for each row 
begin  
  if :new."PRODUCTID" is null then
    select "PRODUCT_SEQ".nextval into :new."PRODUCTID" from dual;
  end if;
end;
/   


create table "CATEGORY" (
    "CATEGORYID"   number not null,
    "CATEGORYNAME" varchar2(100),
    constraint  "CATEGORY_PK" primary key ("CATEGORYID")
)
/

create sequence "CATEGORY_SEQ" 
/

create trigger "BI_CATEGORY"  
  before insert on "CATEGORY"              
  for each row 
begin  
  if :new."CATEGORYID" is null then
    select "CATEGORY_SEQ".nextval into :new."CATEGORYID" from dual;
  end if;
end;
/   

alter table "PRODUCT" add ("CATEGORYID" number);
/

alter table "PRODUCT" add constraint "PRODUCT_FK" 
foreign key ("CATEGORYID")
references "CATEGORY" ("CATEGORYID")
/