Checking when a row was last modified
[123 byte] By [rmgunduza] at [2007-11-27 7:08:51] 
I want to get rows insert and last update time, without using user-defined colons. how can i do?Thanks
«« JSF do not work in Weblogic9
»» Urgent - pls help - Problem while inserting binary file into Oracle DB
»» Urgent - pls help - Problem while inserting binary file into Oracle DB
# 1
RMG,
I believe that will depend on the DBMS you are interacting with.
Forgive me, but I couldn't find that information in your post.
Or is this a trick question?
As far as I know, with Oracle DBMS you cannot access this information even though Oracle does put time stamps on database table rows, I believe. Hence people usually add time stamp columns to their tables and manually keep track of this information.
I am not sufficiently familar with other DBMS's in order to comment on them.
Good Luck,
Avi.
abramiaa at 2007-7-12 19:00:17 >
Database Connectivity Hot Topic
- mysql
- ResultSet Problem
- No suitable driver found for...
- [oracle 10g on SDK 1.6SE] Err Msg: Exhausted Resultset
- where ID = ?... how can i get the ID?!
- Change DB's path
- db connection open
- Help me out with java jeap,saveabend and singal 11 error!
- If Oracle DB Connection goes down,it should reconnect the DB again
- resultset error
- Database location in Applet
- database connectivey
Database Connectivity
All Classified
- Archived Forums
- Enterprise & Remote Computing
- Java Essentials
- Desktop
- Core
- Solaris Operating System
- Security
- Database Connectivity
- Java Mobility Forums
- Web & Directory Servers
- Development Tools
- Application & Integration Servers
- Java HotSpot Virtual Machine
- Other Topics
- E-Mail, Calendar, & Collaboration
- Developer Tools
- General
- Administration Tools
- Sun Hardware
- Storage Forums
- Java Enterprise System
- StarOffice
- Open Source Technologies
- BigAdmin
- Real-Time
- Java Coding