See attachment
James <sqljames_at_aol.com> записано в статью
<373d0dbb.0_at_news.hawaii.rr.com>...
> Does anyone know of a script that can generate a create trigger statement
> from a database(dba_triggers)?
>
> thank you in advance,
>
> -James F.
>
>
>
begin 600 TriggerBody.Sql
M+2T@)C$@+2!/=VYE<@T*+2T@)C(@+2!4<FEG9V5R($YA;64-"@T*<V5T(&YE
M=W!A9V4@,#L-"G-E="!S<&%C92 P#0IS970@:&5A9&EN9R!O9F8[#0IS970@
M<&%G97-I>F4@,#L-"G-E="!L:6YE<VEZ92 Q,# [#0IS970_at_96-H;R!O9F8[
M#0IS970_at_9F5E9&)A8VL@;V9F.PT*<V5T('-H;W=M;V1E(&]F9CL-"G-E="!V
M97)I9GD@;V9F.PT*<V5T('1E<FUO=70@;V9F.PT*<V5T(&UA>&1A=&$@,S(P
M,# [#0IS970@;&]N9R S,3 P,#L-"@T*<W!O;VP_at_5&5X=%PF,2Y?)C(N+E-Q
M; T*#0IC;VQU;6X_at_5%))1T=%4E]"3T19(&9O<FUA="!!,C P,"!7;W)D7U=R
M87!P960-"@T*<V5L96-T("=#<F5A=&4_at_3W(@4F5P;&%C92!4<FEG9V5R("8Q
M+B8R)R!F<F]M(&1U86P[#0IS96QE8W0@<W5B<W1R*'1R:6=G97)?='EP92PQ
M+&EN<W1R*'1R:6=G97)?='EP92PG("<I*7Q\)R G?'QT<FEG9V5R:6YG7V5V
M96YT?'PG($].("=\?'1A8FQE7VYA;65\?"<@1D]2("=\?'-U8G-T<BAT<FEG
M9V5R7W1Y<&4L:6YS='(H=')I9V=E<E]T>7!E+"<@)RDK,2PR-34I('Q\)R G
M(&9R;VT_at_86QL7W1R:6=G97)S('=H97)E(&]W;F5R/5504$52*"<F,2<I(&%N
M9"!T<FEG9V5R7VYA;64]55!015(H)R8R)RD[#0IS96QE8W0_at_5')I9V=E<E]"
M;V1Y(&9R;VT_at_86QL7W1R:6=G97)S('=H97)E(&]W;F5R/5504$52*"<F,2<I
M(&%N9"!T<FEG9V5R7VYA;64]55!015(H)R8R)RD[#0IS96QE8W0@)R\G(&9R
G;VT_at_9'5A;#L-"@T*4W!O;VP@;V9F.PT*<V5T('1E<FUO=70@;VX[
`
end
Received on Tue May 18 1999 - 08:50:51 CDT
