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
m.abdulhaq
Messages: 243
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'


/forum/fa/12322/0/

[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
BlackSwan
Messages: 25853
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
cookiemonster
Messages: 13014
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: Mon Feb 19 20:49:42 CST 2018

Total time taken to generate the page: 0.01693 seconds