User's Manual

200 Appendix D. PDL Syntax
create table paragraphs (
paragraph_id integer
constraint paragraphs_paragraph_id_pk
primary key
constraint paragraphs_paragraph_id_nn
not null,
text clob,
article_id integer
constraint paragraphs_article_id_fk
references articles
constraint paragraphs_article_id_nn
not null
);
create table authors (
author_id integer
constraint authors_author_id_nn
not null
constraint authors_author_id_pk
primary key,
last_name varchar(700)
constraint authors_name_nn
not null,
first_name varchar(700)
constraint authors_name_nn
not null,
portrait blob,
screen_name_id integer references screen_names
);
create table screen_names (
name_id integer primary key,
screen_name varchar(700) not null,
screen_icon blob
);
create or replace function myPLSQLProc(v_priority in integer)
as
begin
insert into magazines (magazine_id, title)
select nvl(max(magazine_id), 0) + 1, :title from magazine_id;
end;
/
show errors
create or replace procedure DataOperationProcWithInOut(
v_new_id IN Integer,
v_copied_id OUT Integer)
as
begin
select max(article_id) into v_copied_id from articles;
insert into articles (article_id, title)
select v_new_id, title from articles
where article_id = v_copied_id;
insert into article_author_map (article_id, author_id)
select v_new_id, author_id from article_author_map
where article_id = v_copied_id;
end;
/
show errors
create or replace function