Hello All, I recently upgraded my Toad client to 9.7.2.5. Almost all of my scripts pass table owner as a variable: Select * from &SCHEMA1.tableA; However when...
I think you are stuck with the new and may I say proper way of handling substitution variables. The Toadies have been making Toad's script handling as close to...
Here's what I found playing with this... ... Enter value for schema: MATTHEW old 1: select * from &schema.dual new 1: select * from MATTHEWdual select *...
When you enclose &schema in double quotes, it becomes case sensitive. Try this select * from &schema .dual; Just put a space after &schema and before the...
William D. Smith
william.d.smith@...
Jun 1, 2009 10:28 pm
47527
Hi there! Is it true,that Quest Sql Monitor doesn't work if ORACLE client is older than 9i. I am not able to test this because of my environment. TOAD is...
I would like to create ERD diagram for whole schema, but it does give me an option for creating for one table only. Â I have toad 9.0.1 Â tahnk you I would...
Hi Omar, Open the Object Palette (View | Object Palette). Now open the ER Diagram window and drag and drop tables (multi-select) from the Object Palette into...
Hi All, I just heard that "SQL Developer" comes with free "DEBUGGER" option. Is it true ? I am a TOAD Lover and do not want to switch to any other tool. ...
Shiva, I thought that debugger was moved into the lowest option set at 9 or 9.7. If you are on maintenance you should be able to download it. My bet it that...
I'm finally on version 9.7.x and have the %datefile% variables at my fingertips. My question: How do I have %datefile% format 060209 rather than 622009? Thanks...
righto From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Tryon, Christopher S Sent: Tuesday, June 02, 2009 2:00 PM To: toad@yahoogroups.com...
Hello folks, I was trying to install toad from our company's internal software sharing site. While doing so, I get this error stating "the following...
What do you mean? The %DATEFILE% variable returns year_month_day: 2009_6_2, for today ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf...
Yeah, this Action proves it. It's compatible with 9.7.2 and Toad 10 (currently in beta). In 9.7.2 it displays 622009, in 9.8/10 beta, 2009_6_2. object...
What would be nice is if you could specify the format of this variable or other variables, so you could custom-form your filenames. I want mine to be...
Not a bad idea, but "/" is not a valid character for windows filenames. ... From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Peter Filias ...
We'll give you credit and put your name in the source code as a comment, how about that? I know it's not cold hard cash, but... ... From: toad@yahoogroups.com...
I like that idea. I just tried to export a dataset (first time doing it) from the editor grid with a variable in the file name. I used %SYSDATE%. So my file...
Use DATEFILE. Sysdate will give you who knows what, depending on your date format. DATEFILE was added as a way to use a date time stamp but have it remove...
Ah ok. I get it. Maybe we need a preview button on the export window for the filename if it contains %variables% :) Ed [TeamT] ... From: toad@yahoogroups.com...
That's a good idea. I see Variables becoming more widespread throughout the product, so eventually such a thing could use a standard approach, to also help...
Does that one crash your system? J Phyllis From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Mark Lerch Sent: Tuesday, June 02, 2009 5:02...
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.
