Menu

#47 Alter table statements not parsed

open
5
2014-09-30
2005-02-22
Jack Walla
No

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.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.