Re: selecting only the fields with the same name from two tables
From: T R <trjunk01_at_hotmail.com>
Date: Thu, 16 May 2002 06:21:31 GMT
Message-ID: <LdIE8.92691$Q42.5104758_at_typhoon.austin.rr.com>
Date: Thu, 16 May 2002 06:21:31 GMT
Message-ID: <LdIE8.92691$Q42.5104758_at_typhoon.austin.rr.com>
select column_name from all_tab_columns where table_name = 'table1'
intersect
select column_name from all_tab_columns where table_name = 'table2'
/
will give you a list of columns that are common to table1 and table2...
"Sanjin" <sanjin.m_at_SoftHome.net> wrote in message
news:abpem3$53cg$1_at_as201.hinet.hr...
> Hello,
>
> I am using oracle 8 and I need to move data from old to new database.
>
> How to get (using sql queries) as the query result from i.e. 'table1' and
> 'table2' only fields that have the same name?
>
> Thanks in advance,
>
> Sanjin
>
>
>
Received on Thu May 16 2002 - 08:21:31 CEST