Red Hat Web Application Framework 6.1 Manual do Utilizador descarregar pdf (Página 214)

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)

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)

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

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

Comentários a estes Manuais

Sem comentários

Red Hat Web Application Framework 6.1 Manual do Utilizador Página 214

Comentários a estes Manuais

Manuais e produtos relacionados com Manuais de software Red Hat Web Application Framework 6.1