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
110
votes
15 answers

Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

Is there a workaround for 'ORA-01795: maximum number of expressions in a list is 1000 error' I have a query and it is selecting fields based on the value of one field. I am using the in clause and there are 10000+ values example: select field1,…
valmont74
  • 1,177
  • 3
  • 12
  • 13
82
votes
2 answers

How can I get all sequences in an Oracle database?

Is there any command that I can run so that I can get all the sequences? I am using Oracle 11g. I am using Toad for Oracle to connect to it. I can visually see the sequences in Toad, but I like to know the command line for it.
sheidaei
  • 9,842
  • 20
  • 63
  • 86
68
votes
7 answers

Weird characters added to first column name after reading a toad-exported csv file

Whenever I read a csv file in R (read.csv("file_name.csv")) that was exported using toad, the first column name is preceded by the following characters "ï..". Also, opening the csv file in excel or notepad++ shows up correctly (without the preceding…
amunategui
  • 1,130
  • 2
  • 11
  • 15
47
votes
4 answers

Searching for Text within Oracle Stored Procedures

I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for anywhere that the developers used MAX + 1 instead of the NEXTVAL on the sequence to get the next ID number. I've been doing SQL Server for years…
PseudoToad
  • 1,504
  • 1
  • 16
  • 34
47
votes
9 answers

How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554',…
CHHIBI AMOR
  • 1,186
  • 2
  • 13
  • 27
40
votes
3 answers

How to turn on table name autocomplete feature in Toad?

I'm using Toad version 11.0.0.116. I'm not getting default tablename options when I start typing table. How to turn the autocomplete feature on??
star09
  • 401
  • 1
  • 4
  • 4
33
votes
9 answers

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I accessed the same database…
Pseudonymous
  • 625
  • 1
  • 5
  • 13
29
votes
10 answers

Toad for Oracle..How to execute multiple statements?

I have some 800-1200 INSERT statements generated from an excel sheet. I want to run these in TOAD - Oracle db. If I press F9, it runs only one line and F5 gives me syntax issue and do not seem to work? What am I missing here?
user1191463
  • 395
  • 2
  • 5
  • 12
27
votes
7 answers

Is there anything as good as TOAD for Postgres (Windows)?

I'm just looking for a management tool like TOAD for Postgres. Anyone used a good one? Edit - I work mostly within the data itself and the database already has a mature model/design. I use the edit windows the most (well, in TOAD for Oracle…
misc090912
24
votes
4 answers

How to escape ampersand in TOAD?

When I try to insert a value which has '&' in TOAD I get a prompt for a substitution variable. So when I try: insert into x values('hello & world'); it throws a prompt for substituting the variable 'world'. I have tried right clicking in the…
Utham Radipe
  • 343
  • 1
  • 2
  • 5
23
votes
2 answers

How to debug a stored procedure in Toad?

I have Oracle 10g installed and there is a package which has a number of cursors and procedures, how do I debug one of these procedures or cursors. Can you please provide steps for that? I ran a Google search but did not find anything specifying…
Sandeep Kumar
  • 13,799
  • 21
  • 74
  • 110
21
votes
1 answer

Displaying RowID in Select * (all) Statement

I am trying to display the RowID alongside all columns from a Select * statement. I am using Oracle with Toad to run the SQL statement. I have two tables that I need to compare, but I do not have any unique identifiers to use when sorting the two…
Marwan مروان
  • 2,163
  • 8
  • 30
  • 40
17
votes
1 answer

Creating a table from a query using a different tablespace (Oracle SQL)

I want to create some tables in our database from some queries I have developed. I used the code below and it created the table and it works great. The issue I am having is apparently it created the table using a different tablespace than the one…
user1723699
  • 1,031
  • 6
  • 13
  • 27
17
votes
3 answers

How to extract table definitions using SQL or Toad

Can somebody tell me how to extract my table definitions using SQL? I want to extract the datatypes of all my tables and other information from my Oracle schema. I have about 100 tables. I need the complete documentation of my Oracle Schema. My…
santhosha
  • 619
  • 6
  • 14
  • 23
16
votes
5 answers

How to get information about compile error in Oracle/TOAD

I'm using TOAD to develop a stored function in an Oracle database. When I click the "run as script" button in TOAD, it tells me that the script was executed with 0 errors and 1 compile errors. Where do I see the specific compile error(s). I'm fairly…
Shane Wealti
  • 2,252
  • 3
  • 19
  • 33
1
2 3
…
84 85