Home » SQL & PL/SQL » Client Tools » last data changed (oracle 10g)
last data changed [message #517687] Wed, 27 July 2011 05:20 Go to next message
prashant_ora
Messages: 194
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
Re: last data changed [message #517688 is a reply to message #517687] Wed, 27 July 2011 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 59296
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: last data changed [message #517689 is a reply to message #517687] Wed, 27 July 2011 05:25 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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.
Re: last data changed [message #517697 is a reply to message #517689] Wed, 27 July 2011 05:39 Go to previous messageGo to next message
prashant_ora
Messages: 194
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.
Re: last data changed [message #517698 is a reply to message #517697] Wed, 27 July 2011 05:45 Go to previous messageGo to next message
cookiemonster
Messages: 11000
Registered: September 2008
Location: Rainy Manchester
Senior Member
So this is really a java question and has nothing to do with oracle.
Re: last data changed [message #517699 is a reply to message #517697] Wed, 27 July 2011 05:45 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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.
Re: last data changed [message #517700 is a reply to message #517699] Wed, 27 July 2011 05:50 Go to previous messageGo to next message
knw15pwr
Messages: 130
Registered: March 2010
Senior Member
@Littlefoot : I strongly feel he means "Matrix"
Re: last data changed [message #517702 is a reply to message #517700] Wed, 27 July 2011 05:59 Go to previous message
Littlefoot
Messages: 19653
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh? I thought that data comes in hundreds of kilos (quintals) ./fa/917/0/
Previous Topic: product spy
Next Topic: sqlplus output format
Goto Forum:
  


Current Time: Thu Oct 02 08:53:50 CDT 2014

Total time taken to generate the page: 0.14513 seconds