Hi, I am sorry to post this in the JSP forum. I wish to compare two records of a table and identify the columns with different values. Eg. Table Company_Detail company_name company_Year company_director COY_A 1977 Mr.A COY_A 1977 Mr.B A comparison of the two records in the table must give column "company_director" is different. Typically, record1 and record2 can be got in two objects ; record1.company_name can be compared with record2.company_name ... and so on... but i wonder if there is a method like diff(rec1,rec2) which will return columns which do not match. Please let me know , if there is any way to accomplish this using objects or any other concept.I am using Oracle 8i. Thanks in advance, Vini _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
