OraFAQ Forum: Server Administration » dependencies of field change

Home » RDBMS Server » Server Administration » dependencies of field change (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dependencies of field change [message #628315]

Sun, 23 November 2014 23:26

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

Re: dependencies of field change [message #628316 is a reply to message #628315]

Sun, 23 November 2014 23:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

No such code exist.
Can you write your own script to meet your unique requirements?

Report message to a moderator

Re: dependencies of field change [message #628334 is a reply to message #628316]

Mon, 24 November 2014 03:07

cookiemonster
Messages: 13962
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.

Report message to a moderator

Previous Topic:	Monitoring Export Backup
Next Topic:	SMTP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 22:52:50 CST 2025