Search the web
Sign In
New User? Sign Up
toad · Self Help List for TOAD Development Users
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 24748 - 24777 of 49331   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
24748
I have toad version 7.6 but when connecting to an oracle 10g db i get the following error. is this a toad bug? is there a workaround? or do i need to pay even...
kombrink
Offline Send Email
Nov 1, 2004
11:05 am
24749
So this is a bug?.. And there are no options through toads option to make this possable? Im not sure if i missed an option cheers May seem inisignificant to...
Callender, Kingsley
kingsley.callender@...
Send Email
Nov 1, 2004
1:16 pm
24750
You need to upgrade to version 8 ... From: kombrink [mailto:kombrink@...] Sent: 01 November 2004 11:04 To: toad@yahoogroups.com Subject: [toad] OCI version...
Ed Sheridan
edtoadgroup
Offline Send Email
Nov 1, 2004
1:18 pm
24751
if you get a cached copy from your webservice provider, try this link - it will force a fresh copy to be downloaded... www.toadsoft.com/toadfree.zip?1 -jeff...
Jeff Smith
toaddev
Offline Send Email
Nov 1, 2004
1:23 pm
24752
overlooked this because #3 was no longer in the thread..but saw it again this morning. The product is called "Storage Library" by DeepSoftware. Here's the ...
Mark Lerch
mlerch2002
Offline Send Email
Nov 1, 2004
2:00 pm
24753
Thanks Jeff and Thanks Quest. ... From: Jeff Smith [mailto:jeff.smith@...] Sent: Monday, November 01, 2004 6:24 AM To: toad@yahoogroups.com Subject:...
Michael.Johnston
Michael.Johnston@...
Send Email
Nov 1, 2004
2:17 pm
24754
TOAD 7.6.0.11 ============= When I create script I get something like that: CREATE TABLE TEST_ ( KEY1 NUMBER(3), KEY2 NUMBER(5), F1_VARCHAR2...
smi1955
Offline Send Email
Nov 1, 2004
3:34 pm
24755
Yup View -> Options -> Datatypes -> Include Byte/Char spec when creating DDL from 9i databases ... From: smi1955 [mailto:smi1955@...] Sent: Monday,...
Jeff Smith
toaddev
Offline Send Email
Nov 1, 2004
3:37 pm
24756
- Thanks a lot. It works, no problem. ... creating DDL ... script" ... find...
smi1955
Offline Send Email
Nov 1, 2004
3:53 pm
24757
Ah I was alwasy curious about this! Never got around to figuring out why. Thanks for the tip Jeff. Gio ... http://www.toadsoft.com/faq2.html ... to...
Giovanni Jaramillo
jaramill99
Offline Send Email
Nov 1, 2004
9:00 pm
24758
Its not really an issue, unless you are on a db with a NLS_LANG that uses > 1 byte per character. In some cases you could be using 4 Bytes per character and...
Jeff Smith
toaddev
Offline Send Email
Nov 1, 2004
9:21 pm
24759
the following code returns a varray of user defined object types, works fine in sql*plus but toad gives the following errors select...
Ian Turnbull
pvfc_2000
Offline Send Email
Nov 2, 2004
3:06 pm
24760
Hi, I'm a novice SQL programmer. We use TOAD to write SQL. I would like to write a SQL and export the output to a text file. I know that TOAD has the "save...
nick05142002
Offline Send Email
Nov 2, 2004
3:16 pm
24761
I think we can help you do this now. Important 1st question: What version of Toad are you using? -jeff ... From: nick05142002 [mailto:nick05142002@...] ...
Jeff Smith
toaddev
Offline Send Email
Nov 2, 2004
3:41 pm
24762
What client and database versions are you using? There are a few notes on Metalink that mention 8i clients against 9i databases giving this error e.g. ...
kevin.angus@...
kangus2000
Offline Send Email
Nov 2, 2004
3:50 pm
24763
Will the reply be to the list Jeff? I'd be interested as we currently Email text output but would like to export and email it as an attachment rather than csv...
stephen.baker@...
steve_at_wor...
Offline Send Email
Nov 2, 2004
3:51 pm
24764
... From: Mauro Papandrea [mailto:mauro.papandrea@...] Sent: Tuesday, November 02, 2004 10:47 AM To: Jeff Smith Subject: QSR request Sorry to...
Jeff Smith
toaddev
Offline Send Email
Nov 2, 2004
4:01 pm
24765
what format do you want? you can run toad from command-line, open connection, run query, save query results to any of the SaveAs options, close toad. so, you...
Jeff Smith
toaddev
Offline Send Email
Nov 2, 2004
4:04 pm
24766
I'm not sure if this helps or not but here are some sql*plus commands that Toad and QSR also recognize. Adding "spool my_file.lst" (without quotes) at the...
fred ames
amesclar
Offline Send Email
Nov 2, 2004
4:17 pm
24767
I am using version 8.0 - Nick I appreciate your assistance ... would ... is ... into ... find...
nick05142002
Offline Send Email
Nov 2, 2004
4:23 pm
24768
many thanks to all those who responded to this. it was the 8i 9i client problem, changing the toad connection to 9i resolved the issue. thanks ... From:...
Ian Turnbull
pvfc_2000
Offline Send Email
Nov 2, 2004
4:25 pm
24769
In the save As dialog - hit this button The resulting file will have instructions for command-line operation. That should get you going. -jeff ... From:...
Jeff Smith
toaddev
Offline Send Email
Nov 2, 2004
4:31 pm
24770
I presume what you want is to have the output of a SELECT statement SPOOLed to a file. This however means you have to read up on SQL*Plus and the different...
Erwin Rollauer, Mr
erwinrollauer
Offline Send Email
Nov 2, 2004
4:42 pm
24771
This guy has Toad, and now you want him to torture himself learning SPOOL? :) ... From: Erwin Rollauer, Mr [mailto:erwin.rollauer@...] Sent: Tuesday,...
Jeff Smith
toaddev
Offline Send Email
Nov 2, 2004
4:55 pm
24772
Here is a table dump script (i.e. dump.sql): Bert set linesize 1000 set pagesize 0 set verify off set feedback off set trimspool on col dummy1 noprint col...
Bert Scalzo
bscalzo
Offline Send Email
Nov 2, 2004
6:10 pm
24773
Here's the version if you don't want the INSERT command, but rather just the data (unload.sql): Bert set linesize 1000 set pagesize 0 set verify off set...
Bert Scalzo
bscalzo
Offline Send Email
Nov 2, 2004
6:13 pm
24774
Its unfortunate, but I think that Erwin is right. Ideally I want to spool a text file using TOAD, but I do not think that is possible. I know that TOAD is...
nick05142002
Offline Send Email
Nov 2, 2004
6:28 pm
24775
Its unfortunate, but I think that Erwin is right. Ideally I want to spool a text file using TOAD, but I do not think that is possible. I know that TOAD is...
nick05142002
Offline Send Email
Nov 2, 2004
6:28 pm
24776
Its unfortunate, but I think that Erwin is right. Ideally I want to spool a text file using TOAD, but I do not think that is possible. I know that TOAD is...
Nick Licata
nick05142002
Offline Send Email
Nov 2, 2004
6:28 pm
24777
i'm not sure if this is something that would be done through Toad or with SQL commands. i'm trying to automate a process where we have a comma delimited batch...
Big Total
totalsteel
Offline Send Email
Nov 2, 2004
7:48 pm
Messages 24748 - 24777 of 49331   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help