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
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...
UK court system
important for life in the uk test
No comments:
Post a Comment