Rob, I also had a similar rant about the term "A standard database table", but decided that I didn't have the energy to put it into print. Apparently you are more energetic that me. :-) Furthermore, I fail to see how any of Latha's 3 solutions addresses the problem posed by Dhivya, but perhaps Dhivya will understand and that's all that really matters. If he doesn't understand then it's up to him to ask for clarification.
Regards, Mike On Thu, Sep 25, 2008 at 1:27 PM, rob wolfe <[EMAIL PROTECTED]>wrote: > > I have to pipe in here because there is no such thing as a standard > database table. There are standard tables for Oracle E-Business suite > .. but that is not at all the same thing. > We have to remember on here that while many folks are in an Oracle > E-Business environment there are just as many, or perhaps more, that are > not running in that environment. Calling something a "standard database > table" is a very bad habit to get into especially if you ever take a > position outside the Oracle E-Business environment because you will be > in for a rude shock if you expect such niceties as created by, creation > date, last updated and last updated by to magically exist in tables > outside that environment. > > Sorry if I sound harsh on that but one of my pet peeves is folks that > are used to working in Oracle Financials (for instance) and think that > it is the only way to design a database. Not every environment needs the > amount of , for lack of a better term, extra stuff (like time stamps, > user stamps .. etc) that an enterprise level ERP system needs and thus a > lot of them wont have them so don't get used to having them available. > > </rant> > > Latha wrote: > > There are several ways. few of them are > > > > 1. Capturing the database updates thru log file/table and acquiring > > the same whenever required. > > > > 2. writing a trigger after update > > > > 3. A standard database table will always contain the last updated > > timestamp and last updated user name. it is used to get the recent > > modified time > > > > > > Regards, > > Latha > > > > On Thu, Sep 25, 2008 at 9:51 AM, dhivya <[EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > > > > > In Detail: > > Say, I read all the data into my vb form from an Oracle table. And I > > need to know whether it has been updated after that without reading > > the same data again. > > > > > > > > > > > > > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
