| readonly TOAD...and a lacy guy [message #426855] |
Tue, 20 October 2009 01:56  |
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 #426890 is a reply to message #426855] |
Tue, 20 October 2009 04:20  |
 |
Littlefoot
Messages: 21823
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;
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 #435882 is a reply to message #435880] |
Fri, 18 December 2009 09:11 |
cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
wvu1999 wrote on Fri, 18 December 2009 15:05It'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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
