OraFAQ Forum: SQL & PL/SQL » how to know whether an update or insert happened due to an insert or update statement

Home » SQL & PL/SQL » SQL & PL/SQL » how to know whether an update or insert happened due to an insert or update statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to know whether an update or insert happened due to an insert or update statement [message #192106]

Sun, 10 September 2006 23:57

uday.y
Messages: 2
Registered: September 2006
Location: india

Junior Member

Hi,

How can i know whether an update or insert happened due to an update or insert statement.

I want to know how many rows were updated due to the update statement.

Report message to a moderator

Re: how to know whether an update or insert happened due to an insert or update statement [message #192112 is a reply to message #192106]

Mon, 11 September 2006 00:27

dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai

Senior Member

hi,

 you can use rowcount.

regards,

Report message to a moderator

Re: how to know whether an update or insert happened due to an insert or update statement [message #192113 is a reply to message #192106]

Mon, 11 September 2006 00:39

venkatbollu
Messages: 53
Registered: April 2005
Location: Bangalore

Member

Hi,

Use the following statement after the insert or update statement

IF SQL%rowcount >0 THEN
   DBMS_OUTPUT.PUT_LINE ( 'SQL%rowcount= ' || SQL%rowcount );
END IF;

Thks & Rgds
Venkat

Report message to a moderator

Re: how to know whether an update or insert happened due to an insert or update statement [message #192123 is a reply to message #192113]

Mon, 11 September 2006 01:47

uday.y
Messages: 2
Registered: September 2006
Location: india

Junior Member

Thank you,

Report message to a moderator

Previous Topic:	local system logon as sysdba
Next Topic:	inserting into table row-by-row.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 16:40:59 CST 2024