I want to change product line for more than 900 items. Is there any simple way present where I can change product line from old to new in a single run instead of changing it for each Item.

Hi,

As I understood you wanted to change some field in some table. In that case you can write a session which will change that field based on some criteria and update the same.

If criteria is based on some index key in that case you can try thru table level also.

regards,

ajay mishra

Or maybe you can use an exchange scheme. We do that a lot to update fields on a table.

you're using oracle! use a sql statement to do it!! ! =)

Dave