Home » SQL & PL/SQL » SQL & PL/SQL » sql help (update)
sql help [message #306186] Thu, 13 March 2008 03:27 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member

HI

i want to retrive data  two tables with depended on condition.

asume that 
select a.empno,b.loc from emp a ,dept b
where a.deptno=b.deptno

than i want to update coloumn  e.sal ='y'.

................................................
this logic i want to sigle sql query.


thanks
srinivas





Re: sql help [message #306187 is a reply to message #306186] Thu, 13 March 2008 03:30 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
UPDATE, see examples.

(Seems to be the great question today, 3 times I post this link in a couple of hours.)

Regards
Michel
Previous Topic: Pls solve the query
Next Topic: Exponential values in oracle.
Goto Forum:
  


Current Time: Sun Aug 20 08:48:53 CDT 2017

Total time taken to generate the page: 0.13537 seconds