Blame | Last modification | View Log | Download | RSS feed
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 ®MON_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 ®MON_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;