update entire without writing all column names
Posted by:
elona b
Date: August 24, 2009 06:52AM
hi,
i'm having some problems, i want to make an update to one row of a table without writing all columns but just the new values. i can't get it working... this is how i try. this is just a simple test with a table with 2 columns, id and name.
update test set values(333, 'yyy') where id = ;
how can i deal with it?
thnx for any reply
Subject
Views
Written By
Posted
update entire without writing all column names
3941
August 24, 2009 06:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.