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 144 times)
Re: Update table problem [message #211674 is a reply to message #211669] Sun, 31 December 2006 03:14 Go to previous message
Messages: 20847
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: Tue Oct 25 02:04:49 CDT 2016

Total time taken to generate the page: 0.07022 seconds