if i m not clear in the previous post:
i have a dat file with two columns. and a database table (oracle).One field of that file nd table r same. i want to match each value of tht column of that table with that of file.pick up the correspionding other column value frm the file and replace it in the same column of that table.
i want to write it in a single shell.