User's Manual

Appendix D. PDL Syntax 199
where relation_type = :relationType)
connect by prior related_category_id = category_id
start with category_id = :categoryID) m,
cat_categories c
where c.category_id = m.related_category_id
} map {
level = m.l;
categoryID = c.category_id;
name = c.name;
description = c.description;
isEnabled = c.enabled_p;
}
}
Example D-1. Usage Reference for PDL
create table publications (
publication_id integer
constraint publications_pub_id_nn
not null
constraint publications_pub_id_pk
primary key,
name varchar(400)
constraint publications_pub_id_nn
not null
);
create table magazines (
magazine_id integer
constraint magazines_magazine_id_fk
references publications
constraint magazines_magazine_id_pk
primary key,
issue_number varchar(30)
);
create table articles (
article_id integer
constraint articles_article_id_pk
primary key
constraint articles_article_id_nn
not null
title varchar(700)
constraint articles_title
);
create table magazine_article_map (
magazine_id integer
constraint mag_article_map_mag_id_nn
not null
constraint mag_article_map_mag_id_fk
references magazines,
article_id integer
constraint mag_article_map_article_id_fk
references articles
constraint mag_article_map_article_id_nn
not null,
page_number integer
);