Subversion Repositories Sigmater

create table WS_APPLICAZIONI
(
  COD_APPLICAZIONE NUMBER(10) not null,
  NOME             VARCHAR2(255) not null,
  DESCRIZIONE      VARCHAR2(255) not null,
  FLAG             VARCHAR2(1),
  FLAG_RISERVATO   VARCHAR2(1),
  URL              VARCHAR2(255)
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_APPLICAZIONI
  add constraint PK_WS_APPLICAZIONI primary key (COD_APPLICAZIONE)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
grant select on WS_APPLICAZIONI to &MONIT_USER_NAME;
grant select on WS_APPLICAZIONI to PUBLIC;