Questions tagged [toad]
Toad is software for database administration.
18
questions
0
votes
0
answers
13
views
how to open .ter file saved from toad for db2
I have saved diagram from toad and it is extention is .ter, can anyone tell me hot to be able to open this file in another windows machine
0
votes
0
answers
165
views
Toad -- seeing windows side by side
I'd like to see the SQL editor in TOAD allow one to see windows side by side (as NotePad ++ allows with "move to other view", for example.) My purpose would be to look at to different (but ...
2
votes
1
answer
2k
views
How to capture strings between two words/characters
How to capture strings between two words/characters either or both words have multiple occurrences but I want the words both from the first column.
1. A-Hi hello C-0987654321
2. B-Zzzzzzzzzzzz D-Hi
3....
0
votes
2
answers
2k
views
TOAD(11.5) - DB Connection fails with 'protocol adapter not loadable' , windows 10
It all started with me trying to import 11g db dump into 12c R2 oracle.
DB Dump - 11.02.0
Server - 12.2.0.1.0
I was getting the tns error
'could not resolve connect identifier specified'. After ...
2
votes
0
answers
129
views
Toad alt + tab Not Working - Windows 10
I use windows 10. When I do alt + tab in some windows or another apps there is no problem, they can switch within themselves. But when I open toad i can not use alt + tab, still showing toad.
How ...
1
vote
1
answer
805
views
Toad 8.6.0.38 SQL Editor won't allow editing
I am using Toad for Oracle version 8.6.0.38.
I have found that recently the SQL editor refuses to let me edit anything. If I use the schema browser to generate a select statemnt to the clipboard and ...
0
votes
1
answer
2k
views
Formatting lost when pasting from some non-MS apps to MS Office 365 apps
I use Toad (Quest Software) quite a bit, as well as SQL Developer and Crystal Reports.
In the past, I would copy text from Toad, which had color and is a mono-spaced font, to Word or Outlook, and the ...
0
votes
1
answer
793
views
How to get TOAD to split package file on open?
Somehow my TOAD version-12.8.0.49 setting changed and it no longer splits my Oracle package file on open.
From the F1 Toad Manual:
Save the file. Close the file and open it again. Toad will ask ...
0
votes
3
answers
5k
views
Importing data to Excel does not calculate formulas
I have now read about 40 tips on this subject and it does not appear anybody has a solution other than "click inside the cell and hit enter".
I have to create many spreadsheets with thousands of ...
0
votes
1
answer
1k
views
Toad Query Builder Object Palette is empty
I realize this is a re-ask of In Toad for Oracle's Schema Browser, my Tables list is empty, but I don't have the ability to just add a comment yet.
I'm running Toad 12.6 and I've setup a ...
5
votes
4
answers
23k
views
How to go to Grid view directly when SQL is executed in TOAD?
I have this issue which is really annoying.
When I run a query in TOAD (version 11.5.1.2), it shows the result in Script Output tab, and then within its child Output tab.
The Output tab shows ...
2
votes
1
answer
28k
views
In Toad for Oracle's Schema Browser, my Tables list is empty
In the Schema Browser window of Toad for Oracle 9.7, the list of tables at the left is always empty, though I know the database still has tables. This happens whether I use the Dropdown, Tabbed, or ...
0
votes
1
answer
1k
views
How does excel manage to correctly decode this file contents?
I start with an excel file with the contents in each row:
TEST
çığ
öğö
çüş
Then I export this file as a CSV file and save it as ANSI format (which from what I have read is same as US-ASCII). When I ...
1
vote
0
answers
1k
views
Is it possible to convert .ter to .pdf file?
I have a ER diagram generated from TOAD for mysql. Is it possible to convert the .ter to .pdf?? I couldnt find anything useful on the net. Any suggestions ...
2
votes
0
answers
356
views
How do I enable fully qualified column names in Query Builder in Toad for Oracle?
I've found several hits on google on how to do this in Toad for SQL, but I need the same for Toad for Oracle. (Toad v11).
I'm building a large query where I combine several aliases of the same table (...
1
vote
0
answers
428
views
parallels accessing arbitrary port on host OS from guest OS
I'm running Windows 7 inside of Parallels on Mac OS X 10.7.5. No firewalls have been setup.
From the Mac end, to work remotely I need to VPN into my corp network. Then I use SSH Tunnel Manager to set ...
2
votes
2
answers
36k
views
Status bar quick sum not working
I'm using Excel 2007 for displaying results of various queries I get from TOAD/Oracle. Suddenly it dawned on me that the Auto Calculations on the bottom status bar are not working even though ...
0
votes
1
answer
218
views
Any idea why I am getting this error trying to install Toad for MySQL?
I am trying to install toad for mysql and i am getting this error during installation. Any suggestion