Hi All, 1. While accessing TOAD through Citrix server, if one user configures some settings in the TOAD, can it be made not available for other login user? Or...
If I right click on the bottom two lines of the toolbar, the popup has option "Merged" checked. Unless I uncheck it, TOAD does not allow me to customize any...
I looked in the options for toad, but did not see that. Do you have a tab and location for this button? "Gregory Liss" <gregory.liss@...> "Gregory Liss"...
Robert W Franklin
rfranklin@...
Apr 1, 2007 3:40 pm
36671
Options -> Oracle -> Transactions -> Execute scripts in TOAD session. checked - scripts execute in same TOAD session as the editor. unchecked - scripts execute...
Each OS user gets their own set of options. All options are stored on the citrix server by default. ... From: toad@yahoogroups.com on behalf of vvetri74 Sent:...
as far as I know, I did not change anything to the default. Toad only reacts this way with a date, all other data displays normal. Is there a menu option or...
Fellow TOADies, I replied to an email on Toad & Subversion this morning and it bounced back. The email address is unknown. I'm resending it via the list as it ...
I have tried to install Toad 9.0.1.8 on Linux (Fedora Core 6) under Wine (Windows emulator). I downloaded Oracle instant client 10.2.0.2. I put Oracle drivers...
Shoo, I am glad that I am not the only one getting the problem. Thanks Nathaniel for the better explanation. I have just upgraded to SQL*NET 10.2.0.3.0 and...
Hi, i am executing the following query it is giving non-numeric character was found where a numeric was expected. select indate from leave.tt_info where indate...
hari
tr_hariprasath@...
Apr 2, 2007 12:54 pm
36678
Hi All, Once the authorisation string is supplied, the OK button doesn't get enabled to continue. I uninstalled the Toad application and installed again....
note that you can NOT use a trial version to enter a license key - it will not enable the button as you said. You must do installs from an official commercial...
Afternoon Hari, ... to_date('01-Apr-2007') ... You probably need something like : where indate = to_date('01-Apr-2007', 'dd-Mon-yyyy') Perhaps - your date...
The problem seems to be solved with the Beta version 9.1.0.27 I will monitor for the rest of the week and give some more feedback on Thursday. Jimmy ...
How can I reset the toolbars to be the same as they were when I first installed Toad? ... This message, including any attachments transmitted with it, is...
Ken Hughes
kenh@...
Apr 2, 2007 9:01 pm
36683
To all: We are running Toad for Oracle 8.6 here over an Oracle 8.1.7.4 database with Oracle client 8.1.7.4.13. We made some changes to several of our large...
The Toad code road map could be a lot better and very useful. The relationship lines need to be movable to any side of a box they point to or come from. The...
Ken Hughes
kenh@...
Apr 2, 2007 9:02 pm
36685
What is your NLS Date Format? You might want to try the following instead: select indate from leave.tt_info where indate = to_date('01-Apr-2007','DD-MON-YYYY')...
Mason, Pat
PatMason@...
Apr 2, 2007 9:03 pm
36686
I tried the following in an Oracle 10 database select to_date('01-Mar-2007'), 03614, 03614 from dual and it had no problem. When I tried to mess up the month...
I cloned a table that has a TIMESTAMP(5) column and TOAD created the clone with TIMESTAMP(0) --no milliseconds, which are important in this case. When I look...
Wendy Penfold
wpenfold@...
Apr 2, 2007 9:03 pm
36688
I agree with the comment you should always use an explicit format mask. The DBAs can alter the NSF settings all they want. The network can alter the system...
rsimonea@...
Apr 2, 2007 9:04 pm
36689
In your Toad install "User Files" directory delete your toolbars.ini file. Ed [TeamT] _____ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf...
or go to Options > Toolbars and select "Toad Default" ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of...
Select both date fields without using to_date to see the format they are in. Then use to_date or to_char with a format mask to make both dates have the same...
Ken Hughes
kenh@...
Apr 2, 2007 9:09 pm
36692
I have tried to install Toad 9.0.1.8 on Linux (Fedora Core 6) under Wine (Windows emulator). I downloaded Oracle instant client 10.2.0.2. I put Oracle drivers...
Sorry, that didn't do the trick, see results below. SQL plus gives the desired result though, it's only the script output that does this weird thing... Version...
Version 8.6.1 and yes, if I execute the SQL in SQL Plus window, it shows the date in a normal way. Any other ideas? Thanks in advance! Jacqueline ... Of ... ...
Hi Ed, In my glogin.sql there is no mention of a linesize setting and I don't have a login.sql. If I put the command SET LINESIZE 100; at the top, this is the ...
Writin' as purely disinterested observer... looks like a bug. ________________________________ From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On...
When I've experienced that problem, I usually had a string delimiter problem. E.g. A single quote started definition of a string with no closing quote. To find...