I have not seen TDA, I heard that i can post a question on TOAD.
We use Oracle Discoverer to write queries. It’s very diffiult and challenging, so am
looking for a diff tool.
Some questions, please:
a) can i use an Oracle function as a column
b) can i test an Oracle function’s value to filter output
c) suppose i created 10 toad queries
where do the toad queries live,
in other words, in discoverer, i was able to query the discoverer system table and create a query of all the queries? (in discoverer, i use this query that i run in a .bat file to feed an Access mdb form) can i create in tda a query of all queries?
d) is toad password protected, does it use the oracle password?
e) is it easy to install TOAD, i would get the full toad suite,
does the dba have to install to map to the databases?
we have prod tables, test tables, prod data mart, test data mart altogether 4 locations
f) will downloading TDA freeware give me an idea of the product
tx for your advise, sandra