dba_tab_columns
igor z wrote:
>
> Hi,
>
> I am looking for a particular field if it exists in a database. How to
> search all tables for a particular field?
>
> Thanks in advance.
> Igor
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
: Multiple recipients of list ORACLE-L
> Subject: How to search all tables for a particular field?
>
> Hi,
>
> I am looking for a particular field if it exists in a database. How to
> search all tables for a particular field?
select table_name
from dba_tab_columns
where column_name = 'YourFieldName'
Is that what you are looking for?
Gene
--- igor z <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am looking for a particular field if it exists in
> a database. How to
> search all tables for
er and
do this select:
select table_name from user_tab_columns where column_name = '';
Kathy
-Original Message-
Sent: Thursday, July 19, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am looking for a particular field if it exists in a database. How to
search al
select table_name, column_name
from sys.dba_tab_columns
where column_name like 'http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: igor z
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San D
M
> Hi,
>
> I am looking for a particular field if it exists in a database. How to
> search all tables for a particular field?
>
> Thanks in advance.
> Igor
>
> _
> Get your FREE download of MSN Explorer
If it is just a column, try selecting from DBA_TAB_COLUMNS ...
HTH
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: A
a PBS mind in an MTV world
Oracle DBA |
Guidant Corporation |
-Original Message-
Sent: Thursday, July 19, 2001 1:01 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am looking for a particular field if it exists in a database. How to
search all tables fo
Hi Igor,
Try:
Select table_name
from all_tab_columns
where column_name = '';
HTH,
-Rocky
--- igor z <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am looking for a particular field if it exists in a database. How to
> search all tables for a particular field?
&g
>
> I am looking for a particular field if it exists in a database. How to
> search all tables for a particular field?
>
If you really mean all
select table_name
from dba_tab_columns
where column_name = 'FIELD';
Be sure that the field you are looking for is
Hi,
I am looking for a particular field if it exists in a database. How to
search all tables for a particular field?
Thanks in advance.
Igor
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
11 matches
Mail list logo