select dci_text_parse_fnc(3,flv.meaning,’-’) email_address
, flv.start_date_active, flv.end_date_active
from fnd_lookup_values flv
where (flv.lookup_type = ‘SHIPPING_NOTIFICATION_CUST_CAR’
and dci_text_parse_fnc(3,flv.meaning,’-’) is not null
Wejust upgraded from 9.7 to 10.6 and have just started using TDA. Considering using TDA for end user query tool (to replace Oracle Browser).
I have TDA and TOAD open side-by-side and a SQL*plus session open in Putty (AIX).
When I run the exact same query in all three environments - TOAD and SQL*Plus return values right away. TDA is about 5 times slower. Does not matter the order, i.e., TDA first, then TOAD, then SQL, then TDA. REsults the same - very slow performance for TDA.
Feels more like a bad ODBC query than a good SQL*Net query.
This is the query. The function is a public synonym to a custom function.
or flv.lookup_type = 'SHIPPING_NOTIFICATION_CUST')