Reply to: T.o.a.d

[TheFaQQer]

I prefer TOAD to SQL Developer, but there are some annoying features in both of them - like TOAD can't describe an ADT, so I need SQL*Plus instead

Only good thing about SQL Developer is that you don't need an Oracle home to use it.

[Bob Dalek]

Nope.

I use ORASRP - Some Russian bloke wrote it. Not perfect, but neither is the one on MetaLink. And Millsap's is waaayyy too expensive.

[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.

[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

[expat]

Er, it uses extended traces, then? Nope.

Nope.

[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.

[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.

[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.

[vetran]

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

[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).

[Toad]

Watchit you !!

[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.

[lightng]

Have you tried comparing other tables / views using both client tools. Do you get similar results?

Are you using the same connection methods TNS, basic, JDBC Url etc between the two client tools?

[Bob Dalek]

We have got TOAD at work and i'm haivng trouble querying a view on a database...Although the view is there and contains data (proved by using SQL developer client) when i query it in TOAD no data is returned.


Any ideas why this would be and how to resolve it ? It bound to be a checkbox somewhere

Big Thanks in Advance

If it's the correct schema and the underlying tables contain data and the query SHOULD return data, then time to think about VPD.

[Bob Dalek]

Used TOAD here too. It's a bag'o'tulipe. Switched to Aqua Data Studio (freebie). Much happier bunny.

Thanks! Will check it out. TOAD is plop.