Red Hat Web Application Framework 6.1 Manuel d'utilisateur télécharger pdf (Page 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

Commentaires sur ces manuels

Pas de commentaire

Red Hat Web Application Framework 6.1 Manuel d'utilisateur Page 213

Commentaires sur ces manuels

Produits connexes et manuels pour Manuels des logiciels Red Hat Web Application Framework 6.1