Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance. Project price only 1 $
You can buy this project and download/modify it how often you want.
41C:\Dokumente und Einstellungen\smarghitola\Lokale Einstellungen\Temp\Project_V5.dez2010-06-282008-05-21ProjectNameMy descriptionMr. AuthorCopyrightoracle10731PK_%table%%relname%CC_%table%_%column%NN_%column%DEF_%table%_%column%TUC_%table%_%counter%TCC_%table%_%counter%%parent%_%child%_%counter%IDX_%table%_%counter%prompt start create databaseprompt start alter databaseprompt start drop database111111111110001prompt end create databaseprompt end alter databaseprompt end drop databaseDomain11660NUMBER402s42jptoolsdescription
1272NN_a_keyNN_%column%10115210a162Trg_A120The triggerCREATE OR REPLACE TRIGGER %triggername%
BEFORE INSERT ON %tablename% FOR EACH ROW
BEGIN
SELECT %seqname%.NEXTVAL
INTO :NEW.%columnname%
FROM DUAL;
END;A_sPK_%table%40jptoolsThe entity A_s7111PK_A_sPK_%table%10233a_key20Description attribute a_key-1
TCC_B_s_1TCC_%table%_%counter%20(bs_1 is null and d_key is null) or (bs_1 is not null and d_key is not null)2145B_tPK_%table%100jptoolsThe entity B_t4111PK_B_tPK_%table%102323b_key20Description attribute b_key-1
NN_bt_1NN_%column%101154A_BPK_%table%13*******************************************************************************
@generator
@readOnly
*******************************************************************************0a_seqNN_%column%check constraintCC_%table%_%column%default value1jptoolsThe entity A_B
ab
options4233PK_A_BPK_%table%102323a_keyNN_%column%2@generator0a_seqNN_%column%check constraintCC_%table%_%column%default value1Description a_key of A_B-1
NUMBER3801
1273NN_a_keyNN_%column%101152CC_A_B_a_keyCC_%table%_%column%10check constraint11210default value1162b_key30Description b_key of A_B-1
NUMBER3801
101153ab_1NN_%column%40Description ab_1 of A_B-1
VARCHAR24001
NN_ab_1NN_%column%101154IDX_A_B_1IDX_%table%_%counter%20UNIQUEUnique indexUNIQUEindex options00a_key00ASC2ASCmy_expression00my_expressionmy_expressionTrg_A_B130TextCREATE OR REPLACE TRIGGER %triggername%
BEFORE INSERT ON %tablename% FOR EACH ROW
BEGIN
SELECT %seqname%.NEXTVAL
INTO :NEW.%columnname%
FROM DUAL;
END;TUC_A_B_1TUC_%table%_%counter%2@generator0description2224TCC_A_B_2TCC_%table%_%counter%3@generator0check constraintDesccheck constraint21DPK_%table%160d_seqjptoolsThe entity D2121PK_DPK_%table%10232d_keyNN_%column%20d_seqDescription attribute d_key-1
NUMBER3801
12032NN_d_keyNN_%column%101152Trg_D120CREATE OR REPLACE TRIGGER %triggername%
BEFORE INSERT ON %tablename% FOR EACH ROW
BEGIN
SELECT %seqname%.NEXTVAL
INTO :NEW.%columnname%
FROM DUAL;
END;D_vPK_%table%180jptoolsThe entity D_v3111PK_D_vPK_%table%10232d_key20Description attribute d_key-1
a_seq270cyclenoorderNOCACHEff11220jptoolsdescription101122ffNOCACHEcyclenoorderd_seq2031nocyclenoorderjptools10nocyclenoorderProcedure11680jptoolsdescriptionCREATE PROCEDURE %procname%A_view21*******************************************************************************
@generator
@temporality: none
@type: P
@outputName: %name%_io.sql
@templateName: api/iot_a.template
*******************************************************************************0jptoolsThe view ACREATE OR REPLACE VIEW %viewname% AS
SELECT a.a_key
,a1.as_key
,a1.as_1
,a1.as_2
,a1.a_key_2
FROM jptools.a AS a,
jptools.A_s AS a1
WITH CHECK OPTION CONSTRAINT a.a_keyB_kdl_view231jptoolsThe view B_kdl viewCREATE OR REPLACE VIEW %viewname% AS
SELECT b.b_key
,b1.bs_key
,b1.bs_1
,b1.d_key
,b2.c_cd
,b2.bt_1
FROM jptools.b AS b
,jptools.b_s AS b1
,jptools.b_t AS b2
WHERE b.b_key = b1.b_key
AND b.b_key = b2.b_keyD_view26*******************************************************************************
@generator
@type: P
@outputName: %name%_io.sql
@templateName: api/iot_a.template
*******************************************************************************2myThe view DCREATE VIEW %viewname% AS
SELECT d.d_key
,a.a_key
,d1.dv_1
,e.until as eUntil
,f.until as fUntil
FROM jptools.d AS d
,jptools.a AS a
,jptools.d_v AS d1
,jptools.e AS e
,jptools.f AS f
WHERE d.d_key = d1.d_key
AND e.until = f.until
WITH CHECK OPTION CONSTRAINT d.d_keymy.DD_View93*******************************************************************************
@generator
@type: P
@outputName: %name%_io.sql
@templateName: api/iot_a.template
*******************************************************************************3The view DDCREATE VIEW %viewname% AS
SELECT d.d_key
,d1.dv_1
,e.e_key ek
,e.until eU
FROM jptools.d AS d
,jptools.d_v AS d1
,jptools.e AS e -- remember me
WHERE d.d_key = d1.d_key
AND e.until = f.until;
-- gdffgd
--dff
ALTER VIEW %viewname% ADD CONSTRAINT myDD_pk
PRIMARY KEY (dv_1, d_key) RELY DISABLE NOVALIDATEmy.AB_View238*******************************************************************************
@generator
@readOnly
*******************************************************************************4The view ABCREATE OR REPLACE VIEW %viewname% AS
SELECT abl.a_key, abl.b_key
FROM jptools.a_b as ablmy.SamplesView300*******************************************************************************
@generator
@temporality: valid
*******************************************************************************5Temporal testCREATE VIEW %viewname% AS
SELECT id, name, valid_from, valid_till, createDate, updateDate, description
FROM jptools.Samples;
ALTER VIEW %viewname% ADD CONSTRAINT myTem_pk
PRIMARY KEY (id, name, valid_from) RELY DISABLE NOVALIDATEmy.SamplesView2578*******************************************************************************
@generator
@temporality: valid, known
*******************************************************************************6The second sampleCREATE VIEW %viewname% AS
SELECT id, name, known_from, known_till, valid_from, valid_till, createDate, updateDate, description
FROM jptools.Samples2;
ALTER VIEW %viewname% ADD CONSTRAINT myTem_pk
PRIMARY KEY (id, name, valid_from, known_from) RELY DISABLE NOVALIDATEGH_view691*******************************************************************************
@generator
@temporality: valid
@readOnly
*******************************************************************************7GH combined viewCREATE OR REPLACE VIEW %viewname% AS
SELECT G.g_key
,Gv.gv_1
,Gv.gv_2
,Gv.gv_3
,H.h_key
,Hs.valid_from
,Hs.valid_till
,Hs.hs_1
,Hs.hs_2
,Hs.hs_3
FROM jptools.G g
,jptools.G_v Gv
,jptools.H H
,jptools.H_s Hs
WHERE G.g_key = Gv.g_key
AND Gv.known_from <= SYSTIMESTAMP
AND Gv.known_till > SYSTIMESTAMP
AND H.h_key = Hs.h_key
AND Hs.known_from <= SYSTIMESTAMP
AND Hs.known_till > SYSTIMESTAMP
AND G.g_key = H.g_key
WITH READ ONLY;
ALTER VIEW %viewname% ADD CONSTRAINT GH_pk
PRIMARY KEY (g_key,h_key,valid_from) RELY DISABLE NOVALIDATEA_A_s_1%parent%_%child%_%counter%5@NN0description24011verb phraseinverse phrase12A_A_s_1%relname%102420022B_B_s_1%parent%_%child%_%counter%907810100B_B_s_1%relname%102420022B_B_t_1%parent%_%child%_%counter%11071010100B_B_t_1%relname%102420022C_B_t_2%parent%_%child%_%counter%12061000100C_B_t_2%relname%102430023A_A_B_1%parent%_%child%_%counter%14TODO0description213101verb phraseinverse phrase13A_A_B_1%relname%102420022B_A_B_2%parent%_%child%_%counter%15071300100B_A_B_2%relname%102430023D_B_s_2%parent%_%child%_%counter%17016801000D_B_s_2%relname%102450025D_D_v_1%parent%_%child%_%counter%190161800100D_D_v_1%relname%102420022A_A_s_2%parent%_%child%_%counter%2002401100A_A_s_2%relname%102460026G_G_v_1%parent%_%child%_%counter%679067767800100G_G_v_1%relname%102420022G_H_1%parent%_%child%_%counter%681067768001000G_H_1%relname%102430023H_H_s_1%parent%_%child%_%counter%683068068200100H_H_s_1%relname%10242002200PKFKPF*0167772151677721516777215842150400000000110000Arial,9,B,0,clNavy,0Arial,8,B,0,clWindowText,0Arial,8,I,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,01Main Diagram1167772150301100211304837240,167772150,1,4,0
Arial,8,,0,clWindowText,0
1272NN_a_keyNN_%column%101152Trg_A120CREATE OR REPLACE TRIGGER %triggername%
BEFORE INSERT ON %tablename% FOR EACH ROW
BEGIN
SELECT %seqname%.NEXTVAL
INTO :NEW.%columnname%
FROM DUAL;
END;A_sPK_%table%407111PK_A_sPK_%table%102323a_key20-1
NUMBER3801
101152as_keyNN_%column%30-1
VARCHAR24001
NN_as_keyNN_%column%101153as_1NN_%column%40-1
VARCHAR24001
NN_as_1NN_%column%101154CC_A_s_as_1CC_%table%_%column%10as_1 IN ('THIS','THAT')114as_250-1
TCC_B_s_1TCC_%table%_%counter%20(bs_1 is null and d_key is null) or (bs_1 is not null and d_key is not null)2145B_tPK_%table%1004111PK_B_tPK_%table%102323b_key20-1
NN_dv_1NN_%column%101153a_seq27010nocyclenoorderA_view210CREATE VIEW %viewname% AS
SELECT a.a_key
,a1.as_key
,a1.as_1
,a1.as_2
,a1.a_key_2
FROM a AS a
,a_s AS a1
WHERE a.a_key = a1.a_keyB_view231CREATE VIEW %viewname% AS
SELECT b.b_key
,b1.bs_key
,b1.bs_1
,b1.d_key
,b2.c_cd
,b2.bt_1
FROM b AS b
,b_s AS b1
,b_t AS b2
WHERE b.b_key = b1.b_key
AND b.b_key = b2.b_keyD_view262CREATE VIEW %viewname% AS
SELECT d.d_key
,d1.dv_1
FROM d AS d
,d_v AS d1
WHERE d.d_key = d1.d_keyA_A_s_1%parent%_%child%_%counter%502410100A_A_s_1%relname%102420022B_B_s_1%parent%_%child%_%counter%907810100B_B_s_1%relname%102420022B_B_t_1%parent%_%child%_%counter%11071010100B_B_t_1%relname%102420022C_B_t_2%parent%_%child%_%counter%12061000100C_B_t_2%relname%102430023A_A_B_1%parent%_%child%_%counter%14021300100A_A_B_1%relname%102420022B_A_B_2%parent%_%child%_%counter%15071300100B_A_B_2%relname%102430023D_B_s_2%parent%_%child%_%counter%17016801000D_B_s_2%relname%102450025D_D_v_1%parent%_%child%_%counter%190161800100D_D_v_1%relname%102420022A_A_s_2%parent%_%child%_%counter%2002401100A_A_s_2%relname%10246002600PKFKPF*0167772151677721516777215842150400000000110000Arial,9,B,0,clNavy,0Arial,8,B,0,clWindowText,0Arial,8,I,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,01Main Diagram1167772150301100211304849960,167772150,1,4,0
Arial,8,,0,clWindowText,0
1272NN_a_keyNN_%column%101152Trg_A120CREATE OR REPLACE TRIGGER %triggername%
BEFORE INSERT ON %tablename% FOR EACH ROW
BEGIN
SELECT %seqname%.NEXTVAL
INTO :NEW.%columnname%
FROM DUAL;
END;A_sPK_%table%407111PK_A_sPK_%table%102323a_key20-1
NUMBER3801
101152as_keyNN_%column%30-1
VARCHAR24001
NN_as_keyNN_%column%101153as_1NN_%column%40-1
VARCHAR24001
NN_as_1NN_%column%101154CC_A_s_as_1CC_%table%_%column%10as_1 IN ('THIS','THAT')114as_250-1
TCC_B_s_1TCC_%table%_%counter%20(bs_1 is null and d_key is null) or (bs_1 is not null and d_key is not null)2145B_tPK_%table%1004111PK_B_tPK_%table%102323b_key20-1
NN_dv_1NN_%column%101153a_seq27010nocyclenoorderA_view210CREATE VIEW %viewname% AS
SELECT a.a_key
,a1.as_key
,a1.as_1
,a1.as_2
,a1.a_key_2
FROM a AS a
,a_s AS a1
WHERE a.a_key = a1.a_keyB_view231CREATE VIEW %viewname% AS
SELECT b.b_key
,b1.bs_key
,b1.bs_1
,b1.d_key
,b2.c_cd
,b2.bt_1
FROM b AS b
,b_s AS b1
,b_t AS b2
WHERE b.b_key = b1.b_key
AND b.b_key = b2.b_keyD_view262CREATE VIEW %viewname% AS
SELECT d.d_key
,d1.dv_1
FROM d AS d
,d_v AS d1
WHERE d.d_key = d1.d_keyA_A_s_1%parent%_%child%_%counter%502410100A_A_s_1%relname%102420022B_B_s_1%parent%_%child%_%counter%907810100B_B_s_1%relname%102420022B_B_t_1%parent%_%child%_%counter%11071010100B_B_t_1%relname%102420022C_B_t_2%parent%_%child%_%counter%12061000100C_B_t_2%relname%102430023A_A_B_1%parent%_%child%_%counter%14021300100A_A_B_1%relname%102420022B_A_B_2%parent%_%child%_%counter%15071300100B_A_B_2%relname%102430023D_B_s_2%parent%_%child%_%counter%17016801000D_B_s_2%relname%102450025D_D_v_1%parent%_%child%_%counter%190161800100D_D_v_1%relname%102420022A_A_s_2%parent%_%child%_%counter%2002401100A_A_s_2%relname%10246002600PKFKPF*0167772151677721516777215842150400000000110000Arial,9,B,0,clNavy,0Arial,8,B,0,clWindowText,0Arial,8,I,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,0Arial,8,,0,clWindowText,01Main Diagram1167772150301100211304849960,167772150,1,4,0
Arial,8,,0,clWindowText,0
