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.
and I changed all values from found tables.

No comments:

speed test glasgow

at first test upload was 20mbps, something broke it now it gives  0.07 but I am happy with 129 download and price is 16 £