RE: A Trigger question (LENGTHY!)

2001-08-23 Thread Andrey Bronfin
THANKS A LOT FOR ALL WHO REPLIED ! -Original Message- Sent: Wednesday, August 22, 2001 7:12 PM To: Multiple recipients of list ORACLE-L Yes. I was curious, so I did a little test: Create 3 tables. Note the different datatypes. SQL> create table dbm_1 2 (a varchar2(5) not

RE: A Trigger question

2001-08-23 Thread Andrey Bronfin
esoft.com> cc: Sent by:Subject: A Trigger question [EMAIL PROTECTED] 08/22/01 08:56 AM Please respond to ORACLE-L Dear gurus ! sorry for

Re: A Trigger question

2001-08-22 Thread Jared . Still
onfin esoft.com> cc: Sent by:Subject: A Trigger

Re: A Trigger question (LENGTHY!)

2001-08-22 Thread Brian McGraw
Yes. I was curious, so I did a little test: Create 3 tables. Note the different datatypes. SQL> create table dbm_1 2 (a varchar2(5) not null); Table created. SQL> create table dbm_2 2 (a number not null); Table created. SQL> create table dbm_3 2 (a varchar2(5) not

A Trigger question

2001-08-22 Thread Andrey Bronfin
Dear gurus ! sorry for this RTFMable question , just don't have the docs in front of me here . Assume i have a trigger my_trig that performs an insert into tableB after an insert into tableA . The question is : what happens if the trigger gets broken (either disabled , invalid or unable to do what