OraFAQ Forum: SQL & PL/SQL » urgent regarding updating and comparision of records

Home » SQL & PL/SQL » SQL & PL/SQL » urgent regarding updating and comparision of records

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

urgent regarding updating and comparision of records [message #22835]

Thu, 31 October 2002 20:11

sha
Messages: 84
Registered: July 2002

Member

Hi,
How to update a record which has 80 columns.
I dont want to do this way.
update emp set ename='a',sal='12.0','loc='bombay' where eno=1;
not like this.
Is there a way to update the whole the record without specifying each column name.One more thing.I want to compare two records whether they are same or not.How to do this.I mean all the fields should be compared and if any of the column does not match I should know which column is not matching.How to do this?
urgent help me
regards,
Shastri

Report message to a moderator