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.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
speed test hyperoptic
Postgresql group by day, week and month examples
at the end of any product there will be a reporting interfaces for counts. let say you build a advertisement site which gives people to publ...
mounjaro diary day 1
I took the first jab in August 15 around 10:30 in the morning. no pain or nausea or dry mouth, I have been intermittent fasting since 2017 ...
sony xperia 10 VI did not like the case
After iphone 16 I wanted to test an android and looks like sony xperia 10 VI is nice, which is 6.1 inches, but it was narrow and longer than...
No comments:
Post a Comment