30174-1 (663142), страница 7

Просмтор этого файла доступен только зарегистрированным пользователям. Но у нас супер быстрая регистрация: достаточно только электронной почты!

Текст из файла (страница 7)

Pr SmallInt Not Null,

Nal Char(15),

Use_3_Proz Char(1));

create table Type_Nach (

Kod Char(3) not Null,

Naim Char(254) Not Null,

Inp Char(1),

Primary KEY(Kod))

create table Type_Ud (

Kod Char(3) not Null,

Naim Char(254) Not Null,

Primary KEY(Kod))

create table imput_podoh(

kod char(3),

inp char(1))

declare external function sh_date_to_y cstring(4)

returns cstring(4)

entry_point "sh_date_to_y"

module_name "my_funct"

declare external function sh_date_to_m cstring(4)

returns cstring(2)

entry_point "sh_date_to_m"

module_name "my_funct"

create trigger corr_date for nach

Active

Before

Insert

As

begin

New.Data_M=sh_date_to_m(New.Data_G);

New.Data_G=sh_date_to_y(New.Data_G);

New.Data_Ras_M=sh_date_to_m(New.Data_Ras_G);

New.Data_Ras_G=sh_date_to_y(New.Data_Ras_G);

end

create trigger int_nach for Nach

Active

Before

Insert

As

begin

New.Gen=Gen_Id(Numb_Nach,1);

end

CREATE GENERATOR Numb_Nach;

SET GENERATOR Numb_Nach TO 1;

CREATE GENERATOR Numb_Ud;

SET GENERATOR Numb_Ud TO 1;

create view nach_01 (tab_, data_ras_m_, data_ras_g_, sum_)

as

select tab, data_ras_m, data_ras_g, sum(symma)as sum_n

from nach

group by tab, data_ras_m, data_ras_g

create view ud_01 (tab_, data_ras_m_, data_ras_g_, sum_)

as

select tab, data_ras_m, data_ras_g, sum(symma)as sum_u

from ud

group by tab, data_ras_m, data_ras_g

create view fio_01 (tab_, fio_, zeh_, ych_, prin_, yvol_)

as

select tab, fio, zeh, ych, prin, yvol

from fio

group by tab_, fio_, zeh_, ych_, prin_, yvol_

create view fio_02 (ych_, deal_tab_)

as

select ych, count(tab) as deal_tab

from fio

group by ych_

create view zeh_01 (zeh_, naim_)

as

select zeh, naim

from zeh

group by zeh, naim

create view ych_01 (ych_, zeh_, naim_)

as

select ych, zeh, naim

from ych

group by ych, zeh, naim

create view nach_04(data_, sum_, kat_)

as

select data_ras_m, sum(symma), fio.kat

from nach, fio

where nach.tab=fio.tab

group by data_ras_m, fio.kat

create view nach_03(data_, data__)

as

select data_ras_m_, count(data_ras_m_)

from nach_01

group by data_ras_m_

create view nach_05(data_ras_m_, sum_)

as

select data_ras_m, sum(symma/100000)

from nach

group by data_ras_m

Характеристики

Список файлов реферата