T.o.a.d

[lilelvis2000]

How are you quering the view? are you using the schema browser..if so make sure the filter is cleared out. You might see the little red funnel just above the results area.

It saves that between invocations..it catches me out all the time.

Agreed...TOAD is rubbish.

[Toad]

Watchit you !!

[expat]

.....
Agreed...TOAD is rubbish.

Not agreed.

If you're just executing queries, browsing schemas, that sort of stuff, then the important thing is feeling at ease with the interface, and Toad's overly complex for that, but that is because Toad is more.

If you are critically tuning the execution of expensive queries, I don't know a better tool than Toad (excepting a DBA that you can dump the work on).

[vetran]

http://www.indus-soft.com/SynametricsWebApp/WinSQL.jsp

[expat]

http://www.indus-soft.com/SynametricsWebApp/WinSQL.jsp

Oracle database running on unix system. You have a windows PC with a client connection to the db. You are not the DBA so do not have DBA privileges. You want not only to run queries but to observe execution and timings, in real time.

TOAD does that.

[TheFaQQer]

Have you run anything in SQL*Developer that has initialized a context? e.g. setting the applications context to the right user and responsibility before running the query.

Are the NLS Language settings the same between the tools you are using? One may be in English rather than American, for example, which could prevent some data being prevented.

[Bob Dalek]

Not agreed.

If you're just executing queries, browsing schemas, that sort of stuff, then the important thing is feeling at ease with the interface, and Toad's overly complex for that, but that is because Toad is more.

If you are critically tuning the execution of expensive queries, I don't know a better tool than Toad (excepting a DBA that you can dump the work on).

Er, it uses extended traces, then? Nope.

[expat]

Er, it uses extended traces, then? Nope.

Nope.

[Robwg]

Hi,

Are you working with Oracle Financials/ERP business suite? (i.e. Oracle GL, Oracle Payables etc.).

If so - most of the views in that have security built in - you need to set the session context in your TOAD session before selecting from the view. Otherwise no data gets returned.

The other common cause is that the view will be looking at the NLS language settings and you have the wrong setting in your Oracle home.

Let me know if you need more help. This won't be a TOAD problem - it will be something to do with the SQL in the View definition.

Also anyone who says TOAD is rubbish is mental IMO (or not very technical) or just uses the schema browser. TOAD has hundreds of little tricks and features that speed up technical development/support etc. Well worth the 200 quid for a standard licence (if put down as a business expense obviously).

Thanks

Rob

[lilelvis2000]

Its far better than SQL Developer any day. I struggle with TOAD because I haven't a TOAD manual. The client installed this on my machine and that's the only reason I use it.

There really is nothing better though. I've looked around.

Good point, you need to check that you are signing in with the same role assigned.