Red Hat Web Application Framework 6.1 Bedienungsanleitung PDF herunterladen (Seite 213)

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

);

1 2 ... 208 209 210 211 212 213 214 215 216 217 218 ... 229 230

Kommentare zu diesen Handbüchern

Keine Kommentare

Red Hat Web Application Framework 6.1 Bedienungsanleitung Seite 213

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software-Handbücher Red Hat Web Application Framework 6.1