Find table which have LONG column
488408Aug 1 2008 — edited Aug 1 2008Hi All,
I am using oracle 9i in unix box.
In one of my schema i have 1500 tables, some of the tables have LONG column. i dont know which table have Long column.
I want to find the tables which have Long column.
i know desc tablename will give the complete details. but checking 1500 tables is very difficult.
So kindly any one tell me, its any possible solution is there.
otherwise any view will use for this.