replacing a value from one table with the corresponding in other table

Question

0.00/5 (No votes)

See more:

i am having 2 oracle table

one table is having one column named item

in the second table i am having item and code

while selecting the values from table one using select * i want to replace the item with their corresponding code from second table

please help

thanks in advance

asok

Posted 25-Sep-11 21:31pm

asok6783

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2011-09-25T22:25:00

Solution 1

I think you mean you want do do a join on those columns. You want the code column from table2 for every item in table1. Something like this:

SQL

select table2.code 
   from table2
   inner join table1 on table1.item = table2.item;

http://www.orafaq.com/wiki/Equi_join[^]

Good luck!

Posted 25-Sep-11 22:25pm

E.F. Nijboer

replacing a value from one table with the corresponding in other table

1 solution

Solution 1

Add your solution here

Preview 0

replacing a value from one table with the corresponding in other table

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us