... There are several ways to do it but all involve dynamic SQL. Basically you're going to need to write one SQL that's going to generate one or more other...
That is what the SQL Monitor is for. It is located in your Toad directory. Launch it and it has a help file to get it all set up. This utility can see ALL...
Or, in the Schema Browser, you can set the "Filter" options... ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jesse, Rich Sent:...
In SB under schema SYS look at view DBA_TAB_COLUMNS Put in a filter such as COLUMN_NAME LIKE '%USER%' Make sure the text is capitalized Erwin Rollauer, ISR,...
select table_name from sys.dba_tab_columns where column_name like '%string%'; This assumes that you have select privilege on the sys views. Geoffroy...
... The more cynical amongst us would say that Quest acquired TOra to protect TOAD sales, just as they acquired TOAD to protect SQL Navigator sales. Come on...
Hi everyone, I recently had TOAD 8.5 installed and I'm noticing a big problem with the procedure editor. Some packages do not load properly and cause TOAD to...
Hello, When I run the following simple script in SQL Editor: __ Select a.item_no, b.item_no From item_master a, item_inv b Where a.item_no = b.item_no __...
In the Schema Browser click on the Filter icon on the tables tab. Their you will see a filter on column name. I don't know what version you are on but I know...
Talking about slashes, I am using toad 8.0.0.47 and it seems to have the following bug (also found in previous releases) When you login with a anonymous accout...
Go to Tools -> Object Search. For your example use %user%. If you truly want All schemas / owners go to the top of the list and select *ALL USERS. Otherwise...
I have just started experimenting with the debugger, having never really used a debugger before. I used it successfully with a function yesterday, and today I...
you can work around it by adding this line to the query: and 1=1 I will fix it. -John ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com]On Behalf Of ...
I have a coworker who has a fairly simple but long running anonymous block running in a SQL window. He expects it to run for a day or more doing massive data...
John, Where exactly in the Option menu is the switch to turn off the saving of schema browser filters? I tried unchecking "Save filters for lists" (under...
Please don't be afraid, the debugger is your friend and only wants to help you do your work. :) What version of Toad were you working with, if not 8.6? DB...
... I'd hit ok Well, if the Oracle Probe API (the oracle server side debugger service) was timing out, then Toad wouldn't like that so much. Doing re-compiles...
Version 8.5.3.2 toad, Oracle Client Version : 9.2.0.1.0. The schema is owned by a log-in which several of us are sharing (not my idea .. . ) I'm afraid I...
Interesting! I get a "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" when using getstringval(). That's one difference at least....
Having multiple developers share a common Oracle login (schema) is not a good idea for debugging purposes. When Oracle debugger is invloked on a piece of code...
Thanks for the advice, Bert, makes a lot of sense to me. We had to take down the database because my session wouldn't die. I guess I'll lay off the debugger...
Here's a curious question: the clock counting down, does it happen to coincidently match the time difference between midnight and 4pm? Roger S. ... From:...
rsimonea@...
Dec 1, 2005 5:42 pm
30182
Cara, Can you tell me what version of TOAD you're using? Also, can you just execute the procedure (no debugging, breakpoints, watches, ...) without it...
Well... from a business strategy perspective, you're probably not far off the mark. If the code for TOra was produced under an available OSS license (such as...
rsimonea@...
Dec 1, 2005 5:42 pm
30184
Good Morning Cara; My Suggestion: When you run into a situation where you end up failing to be able to compile a stored object (package, procedure, etc),...
rsimonea@...
Dec 1, 2005 5:43 pm
30185
These 2 I think will do it - 1) Save Filters for Lists (Schema Browser - Data) 2) Save Grid Layouts (Schema Browser - Data and Grids) -John ... From:...
Thanks Lynn; I'll have to play around with that. There seems to be some trouble running a network install of Toad against a local user direction. Could also...
rsimonea@...
Dec 1, 2005 5:46 pm
30187
Hey all, I haven't used the Formatter too much because I can't get it to understand exactly how picky I am (hey, it took me 31 years of being overly picky to...
My two cents... I use the debugger frequently. What I would do to reduce contention is to make a copy of the procedure and debug from the copy... That will...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
