Home » SQL & PL/SQL » SQL & PL/SQL » how to list selected field in whole database
how to list selected field in whole database [message #354516] Mon, 20 October 2008 03:05 Go to next message
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
Re: how to list selected field in whole database [message #354521 is a reply to message #354516] Mon, 20 October 2008 03:16 Go to previous messageGo to next message
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
Re: how to list selected field in whole database [message #354522 is a reply to message #354516] Mon, 20 October 2008 03:17 Go to previous messageGo to next message
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.
Re: how to list selected field in whole database [message #354523 is a reply to message #354516] Mon, 20 October 2008 03:17 Go to previous messageGo to next message
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

Re: how to list selected field in whole database [message #354524 is a reply to message #354523] Mon, 20 October 2008 03:18 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Laughing I really need to get back into this! OraFAQ is fast...

MHE
Re: how to list selected field in whole database [message #354527 is a reply to message #354516] Mon, 20 October 2008 03:24 Go to previous messageGo to next message
ejoeyz_85
Messages: 30
Registered: October 2008
Member
which one i need to use? which command? im confusing now
Re: how to list selected field in whole database [message #354529 is a reply to message #354527] Mon, 20 October 2008 03:27 Go to previous message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
???
SELECT Statement with WHERE Clause if you are looking for a specific column.

You can query any one of the views posted above.

Regards,
Jo

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

Report message to a moderator

Previous Topic: convert secconds to day:hour:minute:seconds format
Next Topic: Faster deletion
Goto Forum:
  


Current Time: Thu Nov 14 05:05:23 CST 2024