Update queries

Anon

I want to update a field in one table in an oracle database, using a description field from another table within the same database. Can anyone help???

riese

if i got u right try:

UPDATE table SET field = othertable.description WHERE table.id = blabla

(you'll need the "where" clause to not update the whole table but only one row...)

but perhaps i got you wrong...

greetz

riese

Anon

This does not solve my problem, but thanks. I am getting an error saying invalid column name. I have attached the code. I am very new to SQL so please bear with me.

Update registers_main
set reg_long_desc=unit_instances.fes_long_description
where reg_code like '______l'
and reg_long_desc is null

Cheers
Antony

riese wrote:

if i got u right try:

UPDATE table SET field = othertable.description WHERE table.id = blabla

(you'll need the "where" clause to not update the whole table but only one row...)

but perhaps i got you wrong...

greetz

riese

after thinking one more minute about it i see it couldn't work... sorry.

but try this:

update table set field = (select field2 from othertable where [condition that returns exact one value]) where id = ...

in your case (hope i got it right this time)

update registers_main set reg_long_desc = (select fes_long_description from unit_instances where reg_code like '_____1' [<-- this must be a unique value and reg_code must be in the unit_instances-table...]) where reg_long_desc is null

hope this is workin'

:o)

Anon

Thanks alot. Worked a treat.

Antony

savieira

I want to access a HP-UX oracle database from my linux machine. How can i do this ?

riese

well you'll need to set up oracle client software on your linux-box, add the HP-UX-oracle to the tnsnames.ora and try