Re: compare tables or table columns

"Carlos Martínez Chust" wrote:

> Hi,
> do anybody knows a tool that allow to compare tables or table columns?
> [Quoted]
> Thanks for your help...
>
> --
> Un saludo,
>
> Carlos Martínez

You don't need a tool. Just run a query on the views USER_TABLES and USER_TAB_COLUMNS. For example:

SELECT column_name, data_type
FROM user_tab_columns
WHERE table_name = 'mytable';

You can use the MINUS operator to find differences as in:

SELECT *
FROM user_tab_columns
WHERE table_name = 'mytable'
MINUS
SELECT *
FROM user_tab_columns
WHERE table_name = 'yourtable';

Hope this helps.

Designer will do it ... as will other tools ... but they are all thousands of dollars per copy AFAIK.

Daniel A. Morgan Received on Sat Jul 21 2001 - 23:50:40 CEST