Stack Overflow
Stack Overflow

Questions tagged [toad]

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

Toad is a database query tool from Quest Software. There are versions of Toad that can query Oracle, SQL Server, MySQL, PostgreSQL and more. It provides query editing & reporting, debuggers, performance analyzers and many other tools.

This tag should be used for questions regarding how to use Toad software.

1263 questions
6
votes
3 answers

Toad truncating/rounding large Oracle numbers?

We have a table with a 'price' field of type NUMBER(20,7).. In TOAD I do this: update mytable set price = 1234567890123.1234567; Then I do this select: select price, to_char(price) from mytable PRICE TO_CHAR(PRICE) 1234567890123.12 …
Marcus Leon
  • 55,199
  • 118
  • 297
  • 429
6
votes
5 answers

Why does a query with a sub-select cost less than query with a constant in Oracle

I've got an SQL-table with some million entries and I tried to query how much entries are older than 60 days (Oracle 11.2.0.1.0). For this experiment I used 3 different versions of the select-statement: (The cost-value is given by TOAD for Oracle V.…
Husky110
  • 723
  • 2
  • 10
  • 27
6
votes
10 answers

Why does Oracle not find oci.dll?

I use TOAD 10.2.1.3 under Windows7 and get the following error: Cannot find OCI DLL: C:\Oracle\Product\11.2.0\oci.dll that is strange because exact in the same path I can find oci.dll. That is 64 bit system, that might not be the problem! Any…
maniA
  • 1,437
  • 2
  • 21
  • 42
6
votes
1 answer

ORA-00922: missing or invalid option

IN Toad 9,while executing 'SET DEFINE OFF;' I am getting error as 'ORA-00922: missing or invalid option'
Thush
  • 975
  • 3
  • 8
  • 11
6
votes
5 answers

Toad: Table Autocomplete Functionality Not Working

I've been using Toad for more than a year now without problems. All of a sudden the table autocomplete feature has ceased working. No settings have been changed, and I've clean installed a new TOAD version, yet the problem persists. The image below…
Petteri Pertola
  • 281
  • 2
  • 6
  • 23
6
votes
4 answers

Bring up toad intellisense

When typing a query in Toad it usually brings up an intellisense scrolling box to help with my typing. But sometimes this does not appear. Is there a short cut (like in Visual Studio) to bring it up? EDIT I found that the key mapping is CTRL+. For…
tom
  • 1,822
  • 4
  • 25
  • 43
6
votes
1 answer

Is there a plugin interface in Toad for Oracle?

We want to get some missing functionality into Toad for Oracle. The goal is to add a menu entry that allows to access and modify the text in the editor. Is there some documented plugin interface (like for Eclipse) to write extensions for Toad?
Benjamin Hummel
  • 176
  • 1
  • 6
5
votes
3 answers

Tool for making diagram from SQL query

I have this complicated SQL query for Oracle that I want to visualize in a diagram to make it understandable for my co-workers. I tried at http://snowflakejoins.com but it just chokes on it. Has someone a better suggestion? I prefer a web-app on the…
peter
  • 41,770
  • 5
  • 64
  • 108
5
votes
1 answer

Oracle - Materialized View confusion (is Toad IDE wrong in displaying MV in Tables section?)

I'm confused about Materialized views. Either it is the Toad IDE that I am using that is confusing me, or its that I don't understand MVs enough. I created a materialized view in Oracle by something like this.... CREATE MATERIALIZED VIEW…
contactmatt
  • 18,116
  • 40
  • 128
  • 186
5
votes
1 answer

How to restore TOAD layout to its orginal layout?

How to reset layout to orginal layout. I should get the same layout when first time I installed toad. @Edit-1: - I dont see SQL editor in the red highlighted area. How we can bring that up ?
Jeff Cook
  • 7,956
  • 36
  • 115
  • 186
5
votes
3 answers

Query Help - String in where clause has & character

I am running an SQL (Oracle) statement like that select * from table where table_id in ('265&310', '266&320') While running through TOAD, it consider & as some variable placeholder and it asks for its value. If it was for 1-2 place holders then I…
x.509
  • 2,205
  • 10
  • 44
  • 58
5
votes
1 answer

Update Column value for all rows in Table where Column Value Is Null?

Still learning SQL-Fu, and trying to figure out how to do a simple update on my Table (ex. [TABLE1])to where all rows that have a [COST] column value of NULL are updated to a [COST] value of 0.00. Can anyone show me how this is properly done? I've…
Analytic Lunatic
  • 3,853
  • 22
  • 78
  • 120
5
votes
3 answers

Toad output data grid only shows 500 Rows at a time

I am using Oracle 11g with Toad 12.5.1.1 and the output grid only shows me 500 rows at a time. Is there a way to make toad display all the results at a time or is there a way to find the number of rows returned even though the grid only shows 500…
user4032346
  • 399
  • 1
  • 5
  • 11
5
votes
4 answers

Format sql query in TOAD 7.

In toad's older version i can easily able to format the query in Toad's Query editor by right click > Format Code. But in newer version of Toad 7 i can't able to find this Format option. Can any one help me from where i can Format My Query.…
murtaza.webdev
  • 3,523
  • 4
  • 22
  • 32
5
votes
4 answers

How to export the result into different tabs of Excel in Toad for Data Analyst?

Does anyone know how to export results from more than one query into different sheets of the same Excel workbook using the report automation in TOAD for data analyst? Thank you
Sudha Parajulee
  • 51
  • 1
  • 1
  • 2
1 2 3
…
84 85