| 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: 9248
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
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.
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
