OraFAQ Forum: Server Administration » columns appeared with WHERE

Home » RDBMS Server » Server Administration » columns appeared with WHERE

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

columns appeared with WHERE [message #235501]

Sun, 06 May 2007 23:39

gaur_poonam
Messages: 20
Registered: April 2007
Location: India

Junior Member

hello,
i just want to know that can we track which table columns appear in WHERE clauses and how they are used, from oracle's any view or table.if its possible please give me appropriate name or any information regarding it.

thanks.......

Report message to a moderator

Re: columns appeared with WHERE [message #235502 is a reply to message #235501]

Sun, 06 May 2007 23:47

saibal
Messages: 111
Registered: March 2007
Location: India

Senior Member

Can you clarify exactly what are you looking for?

Report message to a moderator

Re: columns appeared with WHERE [message #235503 is a reply to message #235501]

Sun, 06 May 2007 23:53

gaur_poonam
Messages: 20
Registered: April 2007
Location: India

Junior Member

hello sir,

i want to know that on database at different time we fier different sql statements for getting the result. so when we use a sql with WHERE clause is there any table or view that is maintained by oracle to see that which columns are used with WHERE clause and how they are used.

regards........

Report message to a moderator

Re: columns appeared with WHERE [message #235506 is a reply to message #235503]

Mon, 07 May 2007 00:00

saibal
Messages: 111
Registered: March 2007
Location: India

Senior Member

Sure, if you on are on10g, you can do a lot. You can use flashback transaction query or flashback versions query. More specifically, you can query the view flashback transaction query to get what you are looking for.
But, all these is predicated on your running Oracle 10g.

Report message to a moderator

Re: columns appeared with WHERE [message #235507 is a reply to message #235501]

Mon, 07 May 2007 00:13

gaur_poonam
Messages: 20
Registered: April 2007
Location: India

Junior Member

hi,
i got a table name from which we can do so, but still have some problems trying to solve it, but the table name is col_usage$. may be this is the correct answer.

thanks.........

Report message to a moderator

Re: columns appeared with WHERE [message #235510 is a reply to message #235507]

Mon, 07 May 2007 00:19

saibal
Messages: 111
Registered: March 2007
Location: India

Senior Member

begin
for i in 1..100 loop
dbms_output.put_line('what is your Oracle version?');
end loop;
end;

Report message to a moderator

Previous Topic:	How to set ODBC of Oracle in Windows 2000 Server?
Next Topic:	help on unix command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:50:35 CDT 2024