Home » SQL & PL/SQL » Client Tools » readonly TOAD...and a lacy guy
readonly TOAD...and a lacy guy [message #426855] Tue, 20 October 2009 01:56 Go to next message
thedutchguy
Messages: 13
Registered: October 2009
Junior Member
Hi everybody,

I've got a question about TOAD. We've got the readonly version on our production system and I'm a very lacy guy.

So when I have 3 queries which al generate a different output list but with the same keys, I only want to type in the keys ones and not 5 times.

Example:

select *
from tableA
where colom1 = 245

select *
from tableB
where colom1 = 245

select *
from tableC
where colom1 = 245

I tried with "accept" and &-symbol but then I got the notification "This version of TOAD provides READONLY access'!" Is this possible without changing TOAD

Thanks in advantage,
Re: readonly TOAD...and a lacy guy [message #426857 is a reply to message #426855] Tue, 20 October 2009 02:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64133
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, use SQL*PLus. Wink

Regards
Michel
Re: readonly TOAD...and a lacy guy [message #426885 is a reply to message #426855] Tue, 20 October 2009 03:48 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
What do you get with bind variables:
select *
from tableA
where colom1 = :key_value
Re: readonly TOAD...and a lacy guy [message #426890 is a reply to message #426855] Tue, 20 October 2009 04:20 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have read only TOAD version, but - as you are selecting all (*) from these tables, perhaps you could set table filter in Schema Browser.

Or, create a view as union of these 3 tables, mark records that belong to a certain table and then select from this view. Something like
CREATE VIEW my_view AS
SELECT 'tab A' id, ta.* FROM table_a a
UNION ALL
SELECT 'tab B' id, tb.* FROM table_b b;

SELECT * FROM my_view WHERE id = 'tab A' AND colom1 = 245;
Now you could even parametrize ID and select from whichever table you want. Sort of.

Though, that's probably not a very good idea. (By the way, what is the purpose of using read only version? So that you wouldn't mess something up? If you *know* what you are doing, install free SQL Developer, available at Oracle Technology Network - it will allow you to write your own queries, no matter how they look like.

Or, as already suggested, use SQL*Plus.
Re: readonly TOAD...and a lacy guy [message #427393 is a reply to message #426855] Thu, 22 October 2009 06:27 Go to previous messageGo to next message
thedutchguy
Messages: 13
Registered: October 2009
Junior Member
Oke thanks,


I will try your suggestions...thanks Smile


Re: readonly TOAD...and a lacy guy [message #435880 is a reply to message #427393] Fri, 18 December 2009 09:05 Go to previous messageGo to next message
wvu1999
Messages: 38
Registered: April 2007
Member

It's a public forum. People search the web looking for answers. It's not just YOU reading this, but anyone going forward looking for help.

If you need assistance on how to disable email notifications, just ask.
Re: readonly TOAD...and a lacy guy [message #435882 is a reply to message #435880] Fri, 18 December 2009 09:11 Go to previous message
cookiemonster
Messages: 12418
Registered: September 2008
Location: Rainy Manchester
Senior Member
wvu1999 wrote on Fri, 18 December 2009 15:05
It's a public forum. People search the web looking for answers. It's not just YOU reading this, but anyone going forward looking for help.

If you need assistance on how to disable email notifications, just ask.


Huh? who is that aimed at?
Previous Topic: change isqlplus GUI write area
Next Topic: Client / Server Connection Problem
Goto Forum:
  


Current Time: Thu Dec 08 03:51:27 CST 2016

Total time taken to generate the page: 0.11880 seconds