Ozzy surfing around
taking notes about technology and daily things
Friday, January 27, 2012
find all columns in oracle named as district_id
I had a problem today. it was about changing all district_id in a whole database. so I need to find who used district_id as column name in tables in oracle.
here is how I find it.
Select COLUMN_NAME,table_name from user_tab_columns where table_name in ( select object_name from user_objects where object_type='TABLE' ) and COLUMN_NAME ='DISTRICT_ID'
and I changed all values from found tables.
January 27, 2012
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)