hemachandra

• Mar 6th, 2006

 

Hi

You can write a trigger on that table or u can define a check constraint (I hope you must be having a rule on a column)

developer

• Sep 14th, 2006

 

Hi Hemachander,

Can u give an example.

Thanks.

madhuri

• Feb 23rd, 2007

 

create or replace trigger trg1
after insert or update or delete on tab1

begin

dbms_output.put_line('Changes have been made on table tab1');

end;

askvenki

 Profile Answers by askvenki 

• Aug 13th, 2007

 

Madhuri
This is not possible, where the message will be printed if you execute
Table from another environment like Java, Net. In SQL I think it is not possible.

ramkiibm.yerra

 Profile Answers by ramkiibm.yerra 

• Aug 29th, 2007

 

Madhuri
Its Correct but Its always recomand that you use BEFORE INSERT rather than AFTER INSERT for this situation. This Triggering Environment is applicable to any third-party application also Like JAVA..NET etc

Regds
Ramki YERRA
IBM India Pvt LTD, Bangalore-71
ramakrishna . yerra @ in . ibm . com

SonuYadav

 Profile Answers by SonuYadav 

• Aug 11th, 2008

 

You can user sql%rowcount to check whether the dml does something or not
eg

begin
delete from tbl_xxx
where col_yyy = 'ASDF';
dbms_output.put_line (sql%rowcount);
end;

this way it will return the no of rows deleted

rajivgupta780184

 Profile Answers by rajivgupta780184 Questions by rajivgupta780184

• Aug 12th, 2008

 

CREATE OR REPLACE TRIGGER SHOW_BEFORE_DML
BEFORE INSERT OR DELETE OR UPDATE
ON SERVICE_ORDER_STATUS  --(TABLE NAME)

FOR EACH ROW
BEGIN
 DBMS_OUTPUT.PUT_LINE('NON-UPDATABLE TABLE');
 ROLLBACK;
END;

Thanks
Rajiv Gupta
Yogik Technologies Pvt. Ltd.