Home » SQL & PL/SQL » SQL & PL/SQL » oracle 10g (Update)
oracle 10g [message #428940] Sat, 31 October 2009 00:37 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi experts

When we updated rows in a table using UPDATE statement
how can we know whether those rows are updated or not.

For example i performed update statement

UPDATE emp SET sal=5000
where depeno=10;

How can we find the updated salary Please help me it's very urgent.Thank you in advance.
Re: oracle 10g [message #428949 is a reply to message #428940] Sat, 31 October 2009 01:36 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Laughing

Next query of yours would be,

SELECT SAL FROM EMP
WHERE DEPENO = 10;


And don't worry about updation. Trust Oracle. It will sure update the records according to your UPDATE statements.

regards,
Delna
Re: oracle 10g [message #428957 is a reply to message #428940] Sat, 31 October 2009 02:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't trust Oracle then don't use it... and maybe it is better.

You can also select to get the value, don't you think? (Er, sorry it seems to be a difficult word).

Regards
Michel
Re: oracle 10g [message #429008 is a reply to message #428940] Sat, 31 October 2009 23:36 Go to previous message
halim
Messages: 100
Registered: September 2008
Senior Member

if you are in same session then query

SELECT SAL FROM EMP
WHERE DEPENO = 10;


if you are in another session then don't forget to commit after
update command.

Regards
Halim
Previous Topic: Error logging SQLERRM, FORMAT_ERROR_STACK
Next Topic: storing images in oracle 10g
Goto Forum:
  


Current Time: Thu Dec 08 06:25:49 CST 2016

Total time taken to generate the page: 0.08267 seconds