Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:

Re:

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 19 May 2006 20:00:50 +0800
Message-ID: <074501c67b3b$e16f6a20$6401a8c0@porgand>

> There is no mention of the predicate had coded selected value :
> OWNER='SYS' So I will not be able to generated a statement
> to count the number of rows with the filter OWNER='SYS'. but up to know
> this is the closer to what I am looking for.

You'll get the predicates from v$sql_plan.access_predicates and filter_predicates after parsing or from plan_table if you use explain plan.

Tanel.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 19 2006 - 07:00:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US