In oracle we can get the columns related information for a particular shcema by quering from user_tab_columns. As a administrator I can write a script file which gives the result of the differences if there are any in a given two schemas.
Is there any way to get the column information other than " SHOW FIELDS FROM tablename" ???