Alter table statements not parsed
Status: Alpha
Brought to you by:
altumano
The DDL files generated by PL/SQL Developer look like this:
create table PDC_USERS
(
ID NUMBER not null,
FIRST_NAME VARCHAR2(40) not null,
LAST_NAME VARCHAR2(40),
EMAIL VARCHAR2(256) not null,
ACTIVE VARCHAR2(1) default 'Y' not null,
DEFAULT_PRJ_ID NUMBER,
PRIV_SYSTEM VARCHAR2(1) default 'N' not null,
)
;
comment on column PDC_USERS.PRIV_SYSTEM
is 'Allowed to create a project';
alter table PDC_USERS
add constraint PK_PDC_USERS primary key (ID);
alter table PDC_USERS
add constraint UNQ_PDC_USERS_EMAIL unique (EMAIL);
PL/DOC currently gives a parse error on the ALTER TABLE
statement.