No. However, you can create a VIEW which joins tables (which would need
a primary key) and then you can us the update statement on the VIEW.

Eric


-----Original Message-----
From: Derrick Pitts
[mailto:oracledba-ezmlmshield-x37445532.[Email address protected]
Sent: Wednesday, November 30, 2005 9:20 AM
To: LazyDBA Discussion
Subject: Update statement

Gurus,

I need a little help with an update statement. I'm trying to create an
update statement that joins a table. Will something like this work?

update plmqa.ecs_activity
(SELECT a.ecsactivities_uid
FROM plmqa.ecs_task a, plmqa.ecs_activity b WHERE a.ecsactivities_uid
= b.ecsactivities_uid
AND UPPER (ecsactivities_subject) LIKE '%DELL%')
SET ECSACTIVITIES_UPDATED_DATE = sysdate,
ECSACTIVITIES_UPDATED_BY = '0',
ECSACTIVITIES_STATUS = '0'
where ECSACTIVITIES_STATUS = '1' and ECS_CREATED_BY = '0';

Derrick Pitts, OCP
Database Administrator
Palm Harbor Homes, Inc.
972-764-9403


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page