Re: Database copy question 2 ..(HELP!!!)

SELECT
  'UPDATE ' || TABLE_NAME || ' SET COST = 1 ;' FROM
  ALL_TAB_COLUMNS
WHERE
  COLUMN_NAME = 'COST' ; JK Yao wrote:

> dear all,
>
> Is there any fast way to set all column called 'cost' to 1? Since I
> have 'Cost' column involved in so many table, I need some script of
> special way to done my job.
>
> Please clarify. Thanks a lot.
>
> I use Oracle8.1.6 in Solaris2.6
>
> regards,
> JK
Received on Thu Sep 06 2001 - 11:23:54 CDT