Re: Momentary absence of triggers

I assume you are using SQLPlus windows version ... Aren't you ? .... You accidentally typed the carriage return twice and accidentally hit cancel .....

   ;-)

joseph_sumalbag_at_bose.com

Tony Laaper wrote:

> Does anybody know what might have happened here? (The time delay between
> command and re-issue of command was
> about one second. I was pretty terrified in that one second!) I'm
> absolutely sure no one else was even remotely near the user_triggers
> table. Running 7.3
>
> Screen Capture Starts Here>>
>
> Your Orders, Sir? select table_name, trigger_name, status
> 2 from user_triggers
> 3 where table_name in ('ENCOUNTERS', 'CLINICAL_STAYS',
> 'DELIVERED_PROCEDURES',
> 4 'DELIVERED_DIAGNOSIS', 'PROVIDER_INVOLVEMENTS',
> 'PROCEDURE_INVOLVEMENTS',
> 5 'TRANSFERS', 'GROUPING_RESULTS')
> 6 order by table_name;
>
> no rows selected
>
> Your Orders, Sir? /
>
> TABLE_NAME TRIGGER_NAME STATUS
> ------------------------------ ------------------------------ --------
> CLINICAL_STAYS CLINICAL_STAYS_EDITS ENABLED
> CLINICAL_STAYS CLN_STY_DELETE_TYPE_M ENABLED
> DELIVERED_DIAGNOSIS DEL_DIAG_DELETE_TYPE_M ENABLED
> DELIVERED_DIAGNOSIS VALIDATE_DX_CODE ENABLED
> DELIVERED_PROCEDURES DEL_DELIV_PROC ENABLED
> DELIVERED_PROCEDURES VALIDATE_PROC_CODE ENABLED
> ENCOUNTERS ENCOUNTER_EDITS ENABLED
> GROUPING_RESULTS GROUPING_RESULTS_EDITS ENABLED
> PROVIDER_INVOLVEMENTS PROVIDER_INV_EDITS ENABLED
> PROVIDER_INVOLVEMENTS PRV_INV_DELETE_TYPE_M ENABLED
> TRANSFERS DEL_TRANSFERS ENABLED
> TRANSFERS TRANSFER_EDITS ENABLED
>
> 12 rows selected.
>
> Your Orders, Sir?
>
> << Screen Capture Ends Here
Received on Fri Apr 03 1998 - 00:00:00 CST