OraFAQ Forum: SQL & PL/SQL » how to list selected field in whole database

Home » SQL & PL/SQL » SQL & PL/SQL » how to list selected field in whole database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to list selected field in whole database [message #354516]

Mon, 20 October 2008 03:05

ejoeyz_85
Messages: 30
Registered: October 2008

Member

hello everyone,

i just want to know how to select or list of certain field in database.

let say i want to know TIMECOMPLETED field in which table in whole database

Report message to a moderator

Re: how to list selected field in whole database [message #354521 is a reply to message #354516]

Mon, 20 October 2008 03:16

joicejohn
Messages: 327
Registered: March 2008
Location: India

Senior Member

@ejoeyz_85

Try querying USER_TAB_COLUMNS or USER_TAB_COLS

I think this has been asked and answered before.

Regards,
Jo

Report message to a moderator

Re: how to list selected field in whole database [message #354522 is a reply to message #354516]

Mon, 20 October 2008 03:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Hi, in the Oracle manuals (found here) you can find what you are looking for.

But if I'd say: "have a look at USER_TAB_COLUMNS*", does that help?

MHE

*ALL_TAB_COLUMNS is another option, but then you'd have to take the owner into account.

Report message to a moderator

Re: how to list selected field in whole database [message #354523 is a reply to message #354516]

Mon, 20 October 2008 03:17

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Are you looking for which tables contain a column called TIMECOMPLETED, of for which tables contain a column containing the value 'TIMECOMPLETED'

The first can be solved with the USER/ALL/DBA_TAB_COLUMNS view.
The second is slightly trickier.

{Damn! Didn't even make 2nd}

[Updated on: Mon, 20 October 2008 03:24]

Report message to a moderator