OraFAQ Forum: Client Tools » last data changed

Home » Other » Client Tools » last data changed (oracle 10g)

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

last data changed [message #517687]

Wed, 27 July 2011 05:20

prashant_ora
Messages: 196
Registered: July 2010

Senior Member

Hi,

I have a entry screen, where number of rows and columns are there, now end user can chnage in any row and in any column multiple times, now i have to send only last chnaged
data row and column wise to database,to complte the transaction. Please suggest me what can be the best way to do it.

Thanks
Prashant

Report message to a moderator

Re: last data changed [message #517688 is a reply to message #517687]

Wed, 27 July 2011 05:24

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I have a entry screen

In which tool?

Quote:

Please suggest me what can be the best way to do

What tool and language have you?

Regards
Michel

Report message to a moderator

Re: last data changed [message #517689 is a reply to message #517687]

Wed, 27 July 2011 05:25

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

There should be some kind of a "timestamp" column that would distinguish the last modified record from the others. If there's no such a column, you'll have to add it (ALTER TABLE). One way to populate column value is to write a BEFORE UPDATE database trigger that'll handle the issue.

Report message to a moderator

Re: last data changed [message #517697 is a reply to message #517689]

Wed, 27 July 2011 05:39

prashant_ora
Messages: 196
Registered: July 2010

Senior Member

It's not like that, its a data entry screen developped in java, where data comes in metric fashion from database and we have to send again the chnaged data from the screen to database. So we have to find out which row and which cell of that rows is changed and what is the last value of that particular cell.

Report message to a moderator

Re: last data changed [message #517698 is a reply to message #517697]

Wed, 27 July 2011 05:45

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

So this is really a java question and has nothing to do with oracle.

Report message to a moderator

Re: last data changed [message #517699 is a reply to message #517697]

Wed, 27 July 2011 05:45

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

data comes in metric fashion from database

Sorry for being such an ignoramus, but - what does that mean?

Anyway, from my point of view (which is usually wrong), this is more an application (Java) problem, not Oracle database's one.

Report message to a moderator