Home » SQL & PL/SQL » SQL & PL/SQL » Update table problem
icon6.gif  Update table problem [message #211669] Sun, 31 December 2006 01:08 Go to next message
Messages: 5
Registered: December 2006
Junior Member
I need to update whole column dept_no of  a dept table 
with loc_id  column of location table.

When I issued a cursor ,I can update a column 
of same table with other column of same table.
but,update didn't worked with different tables.

What is the correct solution to this?
  • Attachment: aa.txt
    (Size: 0.54KB, Downloaded 160 times)
Re: Update table problem [message #211674 is a reply to message #211669] Sun, 31 December 2006 03:14 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that there's no 'loc_id' column in the 'dept' table.
Previous Topic: Rollback segment problem during delete
Next Topic: how to call sql loader from pl/sql
Goto Forum:

Current Time: Thu Aug 17 10:44:32 CDT 2017

Total time taken to generate the page: 0.05067 seconds