Super User
Super User

Questions tagged [toad]

Toad is software for database administration.

17 questions
5
votes
4 answers

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 unformatted data, like this: EMPLOYEE_AWARD_ID AWARD_ID…
Ahmad
  • 817
2
votes
1 answer

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 Tree view. In Dropdown view, the top menu is the…
Rory O'Kane
  • 788
2
votes
0 answers

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 (a Kimball-style datamart). I have hundreds of…
gorzan
  • 121
2
votes
2 answers

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 everything that should be ticked is ticked and…
hello_earth
  • 223
2
votes
1 answer

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. C-I want to go to Europe C- Nexy year D-I wish…
Mitchel Araw
  • 23
2
votes
0 answers

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 can i solve this? Thanks
H Bıyıkcı
  • 21
1
vote
0 answers

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 ...
ACP
  • 1,609
1
vote
0 answers

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 up tunnel ports on my localhost (the Mac),…
lostdorje
  • 111
1
vote
1 answer

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 paste it in the editor, I can’t change it. I have…
Choong
  • 11
0
votes
3 answers

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 rows of excel formulas that excel is not recognizing…
red6
  • 21
0
votes
1 answer

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 connection to our Oracle data server. When look in the Schema…
JMichael
  • 123
0
votes
1 answer

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 try to open it with excel again, it correctly…
Cemre
  • 143
0
votes
1 answer

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
leora
  • 6,193
0
votes
0 answers

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 related) SQL query editing tabs, eg: a.sql and b.sql…
JosephDoggie
  • 263
0
votes
2 answers

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 some research , I fixed it by adding oracle home to…
pyroCoder
  • 1
1
2