Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [toad]

Tool for Oracle Application Developers

A SQL development tool from Quest Software

45 questions
22
votes
2 answers

How do you turn off the croak sound for Toad?

How do you turn off this annoying feature? I don't want my DB manager to croak at me as loud as it can.
NoBugsOnlyFeatures
  • 323
  • 2
  • 7
9
votes
4 answers

How to check Oracle database connection encryption type

How to check the Oracle database connection encryption type?(between Oracle database and other client applications)How do I assure between Oracle database and Toad the database connection is encrypted? (My Toad version is 9.5 and Oracle database…
sampathlk
  • 191
  • 1
  • 1
  • 4
7
votes
1 answer

Option to tell Toad to never split a file which contains multiple objects?

Is there an option to tell it to stop prompting me to split a file which contains multiple objects when opening .sql files from an edit window? I never want to split the file!
Cade Roux
  • 6,684
  • 1
  • 33
  • 55
5
votes
1 answer

Why Oracle SQL Developer does not need Oracle client?

I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to require Oracle client.
jrara
  • 5,393
  • 20
  • 58
  • 65
3
votes
1 answer

query to search a particular word/string in toad/oracle

I trying to find out a word/string named 'audapro_ind' in oracle database in toad. This word can be present anywhere in column of table, function, procedure etc. in oracle database I tried few queries like select name , line,text from dba_source…
Sudip7
  • 131
  • 1
  • 1
  • 4
3
votes
1 answer

Can't return data from SQL/Plus and Toad but can from SQL Developer

This one has me stumped. We are running an Oracle 11g on Amazon EC2 and I can connect and query fine with SQL Developer but with Toad and SQL/Plus I can connect but when I try to do a simple select out of v$session for example it gives me an…
Xaroc
  • 33
  • 1
  • 3
3
votes
1 answer

Way to add referencing and referenced entities of a specific entity in E-R Diagram MYSQL

Is there any way to add entities that are referencing a specific entity in an E-R Diagram. I have a database containing 400 tables. I want to see a view containing a specific entity and its referencing and referenced entities. Some MySQL clients…
Jatin Gulati
  • 31
  • 1
3
votes
1 answer

Data too long for column for longtext datatype - MySqlException

I am trying to insert string in LONGTEXT column. Length of string is 75402 and byte count is 150804 (about 147 KB) Throws an exception Data too long for column On inserting record. MySQL document state that LONGTEXT can contains maximum 4GB of…
Munavvar
  • 131
  • 1
  • 1
  • 5
3
votes
3 answers

Printing comments or statements when executing script to a output file using TOAD/ORACLE

Coming from a SQL SSMS environment, I would like to duplicate their Print Command which allows you to print commands or variables while executing a query. I am looking for this feature to help identify particular sections of the script during the…
Hector
  • 1,042
  • 1
  • 8
  • 22
2
votes
1 answer

Could Not Be Accessed Value Of The For Loop Counter In PL/SQL

I try to learn PL/SQL for loops in tutorials. I learn flow of control in a for loops. (And i saw that it is same with most of the other programming languages) Here is the flow of control in a for loop: 1. The initial step is executed first, and…
Mert Özoğul
  • 145
  • 1
  • 7
2
votes
1 answer

Variable Substitution

I am working in TOAD for Oracle and am trying to use variable substitution in my coding. I have been able to get variable substitution to work in the code body pressing F5: Define Value = '1.5' Create table XX_DELETEMEEE as Select percent *…
D_C
  • 123
  • 6
1
vote
2 answers

Set Oracle Home (install Oracle Home) for Toad 12.6

I had Toad 11.5 and I'm trying to install Toad 12.6, to connect to Oracle 11g on a 64-bit Windows 7 machine. No matter what I try, when I start Toad 12.6, I get the error: "No valid Oracle clients found. You need at least one 64-bit client properly…
thursdaysgeek
  • 171
  • 1
  • 1
  • 10
1
vote
0 answers

TOAD query result is cut in the middle

I execute a query eith a long textual column name: select column as "a_very_very_long_field_name" from table; The result looks like : a_very_very_long_fi -------------------- 1. 2. ... Is it possible to set the result for unlimited…
user3165438
  • 131
  • 2
1
vote
1 answer

Toad for Oracle 64-bit : 1603 - Fatal error during installation

I'm trying to install Toad for oracle client, my Toad version is 12.1 for 64 bit system, i have succeeded to install oracle client 12c for 64 bit system, but i have stumbled by a problem when installing the Toad, the error is : The content of the…
Binary Man
  • 11
  • 1
  • 4
1
vote
1 answer

How to use variable and drop in test script?

I have to modify certain Oracle Packages. Basically I will be extracting functionality and moving it to C. They provided me with some "Test" scripts that I shoud be able to run to test that my changes don't break the underlying logic of the package.…
Dzyann
  • 355
  • 3
  • 10
  • 26
1
2 3