Once more do NOT post in UPPER case, split your lines to 80 characters, read SQL Reference for UPDATE syntax and try to do something instead of Always relying on others to do your work and find a more meaningful title than that "need in oracle" you found (of course you need something in Oracle otherwise you didn't post here).