Re: UPDATE SQL

Hi Guyz,

It is working now. I made a mistake in typing the query properly.

Thanx Steve. I got the query as follow.

UPDATE PROFILE_CUSTOMERS SET SP_TYPE_CD = ( SELECT SP_TYPE_CD FROM PROFILE_SP_TYPE_CD
WHERE PROFILE_SP_TYPE_CD.SP_TYPE_NAME = Profile_Customers.SP_TYPE_CD ) WHERE EXISTS
  ( SELECT Profile_sp_type_cd.SP_TYPE_CD     FROM Profile_sp_type_cd
    WHERE PROFILE_SP_TYPE_CD.SP_TYPE_NAME = Profile_Customers.SP_TYPE_CD);

else I have to write the cursor n do that one by one from masters. and for nitely pumps, this will be too time counsuming. This query is not taking even 1 second to update 18000 rows. and I need to do this on couple of more columns too.

Coooooooooooooooooooooooooooooooooooooooooolllllllll........... :-)

Thanx again guyz.
http://www.techonthenet.com/sql/update.htm

• Chirag Majmundar -- http://www.freelists.org/webpage/oracle-l