You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently one may detect that trigger is INactive only by extracting its content. Command `show trigger' does not display such info neither in 2.5 nor in 3.0:
SQL> show trigger;
Trigger name Invalid
================================ =======
TRG_CONNECT
Table name Trigger name Invalid
================================ ================================ =======
AGENTS AGENTS_BI
DOC_LIST DOC_LIST_AIUD
DOC_LIST DOC_LIST_BIUD
. . .
SQL> show trigger trg_connect;
TRG_CONNECT, Sequence: 0, Type: ON CONNECT, Inactive
Trigger text:
as
begin
execute procedure sp_init_ctx;
. . . .
end
It will be useful to add information about INactive trigger(s) to the output of SHOW TRIGGER command.
The text was updated successfully, but these errors were encountered:
This column ("Inactive") could be abbreviated to "Inact." (w/o quotes, of course) - IMO one may easy to understand what this mean.
As for me, there is no problem about exceeding of 80th character: after 1st launch of cmd.exe we can change window properties (increase width) of this by right-clicking on its title bar + save and that's all. It will be auto-restored on all following launches.
PS. Oracle SQLPLUS has many cases when its output exceeds 80 chars, and nobody sees trouble with it :-)
Submitted by: @pavel-zotov
Attachments:
show-trigger-model-sample.PNG
Currently one may detect that trigger is INactive only by extracting its content. Command `show trigger' does not display such info neither in 2.5 nor in 3.0:
SQL> show trigger;
Trigger name Invalid
================================ =======
TRG_CONNECT
Table name Trigger name Invalid
================================ ================================ =======
AGENTS AGENTS_BI
DOC_LIST DOC_LIST_AIUD
DOC_LIST DOC_LIST_BIUD
. . .
SQL> show trigger trg_connect;
TRG_CONNECT, Sequence: 0, Type: ON CONNECT, Inactive
Trigger text:
as
begin
execute procedure sp_init_ctx;
. . . .
end
It will be useful to add information about INactive trigger(s) to the output of SHOW TRIGGER command.
The text was updated successfully, but these errors were encountered: