Home » RDBMS Server » Server Administration » dependencies of field change (Oracle 10g)
dependencies of field change [message #628315] Sun, 23 November 2014 23:26 Go to next message
Messages: 253
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.

  FROM user_tab_columns
 WHERE column_name LIKE '%PS_CODE'


[Updated on: Sun, 23 November 2014 23:27]

Report message to a moderator

Re: dependencies of field change [message #628316 is a reply to message #628315] Sun, 23 November 2014 23:48 Go to previous messageGo to next message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
No such code exist.
Can you write your own script to meet your unique requirements?
Re: dependencies of field change [message #628334 is a reply to message #628316] Mon, 24 November 2014 03:07 Go to previous message
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Writing a bit of PL/SQL that outputs an alter table command for each column isn't difficult, give it a try.
Previous Topic: Monitoring Export Backup
Next Topic: SMTP
Goto Forum:

Current Time: Wed Dec 08 12:48:05 CST 2021