It will be something like
INSERT INTO target_table
(SELECT b.owner_name
FROM driver_table a JOIN owner_table b ON b.owner_name =
a.owner_name);
Mike
On Tue, Jul 12, 2011 at 1:03 PM, Rose <[email protected]> wrote:
> Need to compare the name within two different tables and I am not sure
> how to begin.
>
> I need to get the 1st record from a driver table
> Get the 1st record from the owner table then
>
> Read the 1st character of the driver.driver_name and see if it matches
> the 1st character of the owner.owner_name and continue comparing each
> character for a match. If it matches the entire name, it inserts into
> a new table. If it does not match, move on to the next record in the
> owner table and begin again.
>
> Thank you.
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
