dependencies of field change [message #628315] |
Sun, 23 November 2014 23:26 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c70e51380f6e8af6765f6e8fede51587?s=64&d=mm&r=g) |
m.abdulhaq
Messages: 254 Registered: April 2013 Location: Ajman
|
Senior Member |
|
|
i have to increase the field width of one column existing in several tables , and i used the table user_tab_columns to know where all the fields existing, i just want to know is there any script i can build to increase this particular field length from 12 to 35, the problem is in one table this field is stored with name sl_ps_code and in other table as csd_ps_code.
SELECT *
FROM user_tab_columns
WHERE column_name LIKE '%PS_CODE'
[Updated on: Sun, 23 November 2014 23:27] Report message to a moderator
|
|
|
|
|