Home » RDBMS Server » Server Administration » columns appeared with WHERE
columns appeared with WHERE [message #235501] Sun, 06 May 2007 23:39 Go to next message
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.......
Re: columns appeared with WHERE [message #235502 is a reply to message #235501] Sun, 06 May 2007 23:47 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
Can you clarify exactly what are you looking for?
Re: columns appeared with WHERE [message #235503 is a reply to message #235501] Sun, 06 May 2007 23:53 Go to previous messageGo to next message
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........
Re: columns appeared with WHERE [message #235506 is a reply to message #235503] Mon, 07 May 2007 00:00 Go to previous messageGo to next message
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.
Re: columns appeared with WHERE [message #235507 is a reply to message #235501] Mon, 07 May 2007 00:13 Go to previous messageGo to next message
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.........
Re: columns appeared with WHERE [message #235510 is a reply to message #235507] Mon, 07 May 2007 00:19 Go to previous message
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;
Previous Topic: How to set ODBC of Oracle in Windows 2000 Server?
Next Topic: help on unix command
Goto Forum:
  


Current Time: Mon Dec 05 09:11:42 CST 2016

Total time taken to generate the page: 0.07408 seconds