The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [toad]

Tool for Oracle Application Developers

Filter by
Sorted by
Tagged with
0
votes
1answer
21 views

SQL - Finding Duplicates Across Columns

I have a table that has 4 e-mail fields. A single contact can have anywhere from 1-4 e-mail addresses on file. I'm having trouble writing a query that displays all duplicates across columns. For my ...
0
votes
0answers
9 views

How to log/view remote calls/queries to DB in Toad Data Point?

I am running an Apache Sqoop job from a local computer against an Oracle DB that we connect to via a virtual tunnel and find that for certain large sqoop jobs, the process hangs after a certain X% ...
1
vote
2answers
36 views

Suppress some output from PL/SQL script in Toad for Oracle

Question: In PL/SQL for Oracle running in Toad, can I suppress script output except for certain lines I want to see? e.g. I don't want create table, insert record, drop table. I do want my own ...
0
votes
1answer
27 views

How to see tables and column names in exact case which is created and not by default uppercase?

In toad, whenever I create an object such as a table, If I name columns in PascalCase when it created if I open the table, then toad displays all the column names in uppercase. Is there any option in ...
0
votes
0answers
32 views

Using SQL script in Toad, how do I suppress the echo of the SQL statements

I'm using a script (Toad, Oracle) so that I can use variables and enter two values that get repeated in multiple SQL statements. That's working great, but the SQL statements echo into the console ...
0
votes
1answer
145 views

Database deployment using QSR (Quest Script Runner) is slow

As part of the automatic deployment of a project, we deploy various Oracle scripts (packages, tables, data, etc...) using qsr - Quest Script Runner that is part of Toad. The script executes multiple ...
0
votes
1answer
323 views

Exporting a Database schema and triggers

I have a small problem at work. Our DBA went on a journey of self-discovery ... I am very happy for him and I hope he finds what he is looking for. But he left us without any information about how the ...
13
votes
1answer
2k views

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.
-1
votes
2answers
625 views

Why Toad turned my LEFT OUTER JOIN into a RIGHT OUTER JOIN

I finally figured out the answer but it might be useful for someone looking up the same question so here is the whole write up to hopefully save you the frustration. Problem I had: Toad's query ...
1
vote
2answers
4k views

How to format String with a pattern

I want to format my string in my select statement but I cant seem to find the syntax for this pattern. I have a column of card_num with 16 digits and i want to have a dash(-) after the first four ...
0
votes
2answers
51 views

Update specific rows in a column

I have a column with 82 rows(from table1) and I want to update just the 76 rows in it with different values from another table(table2). Avoiding 6 specific rows(1, 10, 38, 39, 46, 77). Leaving these ...
1
vote
1answer
27k views

DB client tool — To get the error message when open toad oracle client [closed]

I have a serious problem with toad oracle client. I got the error message as following when I open toad client (installed and then opened it): Error: No valid Oracle clients found. You need at ...
2
votes
1answer
5k views

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 ...
0
votes
1answer
94 views

.mdf equivalent for mysql (TOAD) [closed]

What is 'SQL Server Database Primary Data File (.mdf)' equivalent for mysql. I am using 'Toad for mysql' (Vesion 7.7) tool
0
votes
1answer
444 views

Toad For MySql Give error on new connection [closed]

Recently i installed Toad For MySQL latest version but when ever i create new connection i got this error.
0
votes
0answers
4k views

How does Toad detect installed client?

I installed Oracle client and Toad and have worked fine. But When I install Oracle server also in the same system. The server and the client seem to conflict on the path something. I decided to ...
2
votes
1answer
400 views

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 ...
0
votes
2answers
678 views

ORA-01422 Error Occurred When I Call Procedure with Number Parameter

I want to write PL/SQL Procedure that updates salary which is less than 2000. I wrote this procedure.And when i call it with integer id 'ORA-01422: exact fetch returns more than requested number of ...
0
votes
1answer
423 views

SQL for Inserting the system date and a fixed time (not the system time) in a column

I have a query like this: Insert into UNITRIP (START_TIME, END_TIME) (TO_DATE('10/20/2015 06:05:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('10/20/2015 07:34:06', 'MM/DD/YYYY HH24:MI:SS') I require a ...
1
vote
2answers
770 views

How to/Where to find MySQL templates for Toad Data Modeler [closed]

I have recently install Toad Data Modeler 5.3.4 and it only has Oracle data model templates. Where can I find and import the MySQL data templates so that I can create MySQL database models. I have ...
2
votes
1answer
216 views

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' ...
2
votes
2answers
21k views

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 ...
1
vote
0answers
94 views

Toad for Mysql gives error on Compare

I've posted this message on Toad World looking for help but no one has answered. So I'm trying here. I repeatedly get the same error while using any of the Compare options when connecting to a ...
1
vote
0answers
976 views

How to connect to a |Database from SQL Script, in SQL developer

Hi i am trying to connect to a DB using a connection string mentioned in a Script file.. in SQL developer. I am using the below format Connect USERNAME/PASSWORD@HOSTNAME:PORT/Service_name.. But its ...
1
vote
2answers
48k views

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 ...
0
votes
0answers
374 views

Reviewing ways to generate monthly tables using PL/SQL automatically

I am attempting to automate a set of tables that my colleagues produce monthly, using PL/SQL. The set of tables contain data about different metrics (e.g. Customer revenue, customer demographic ...
1
vote
0answers
46 views

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 ...
0
votes
1answer
961 views

Toad 9.7.2 for Oracle hangs on Windows 7

I am using Toad 9.7.2 on Windows 7 64 bit. It is generally working fine but there is one problem. When I click on certain tables in "Schema Browser" and then click on "Data" tab to see records in ...
1
vote
1answer
2k views

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

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 ...
0
votes
0answers
623 views

MySQL select query runs forever in Toad

I'm trying to run a simple SELECT query in Toad (for MySQL 7.2.0.2922). SELECT * FROM sometable When I click execute (or press F9) a small timer shows up in the status bar (bottom right) and it ...
0
votes
2answers
732 views

Which tool enables using SQL query result sets as temporary tables for further analysis and set operations? [closed]

For examples, lets say I need to do set operations and joins on below 3 result sets. I don't want to write a composite query or use temporary database tables. Something which would enable faster data ...
0
votes
1answer
61 views

different outcome based on function execution method

I am mainlining a legacy system and realize that the answer to this may take a deeper explanation of the code but before I go that far I wanted to make sure the solution wasn't something more simple. ...
1
vote
1answer
807 views

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 ...
0
votes
4answers
10k views

Stored Procedure result is not showing in Datagrid pane in Toad for Oracle

I have created a procedure in Toad for Oracle 12. When I execute the procedure it does not show the dataset in datagrid pane, while the procedure is being executed successfully. What I am doing wrong? ...
3
votes
1answer
55k views

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 ...
1
vote
1answer
1k views

Configure MariaDB PAM authentication, and enabling remote login from Toad

I am currently trying to integrate Linux services into my Windows environment and have installed MariaDB with PAM authentication following the guidance from MariaDB. I have tested successfully on ...
5
votes
3answers
13k views

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?...
4
votes
1answer
24k views

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 ...
0
votes
1answer
4k views

Different dates Oracle 11g with TOAD

I have the following queries: SELECT to_date(to_char(to_date('01-FEB-1949'))) FROM DUAL; /*this returns 2/1/2049. */ SELECT to_date(to_char(to_date('01-FEB-1949'),'dd-MON-yyyy')) FROM DUAL; /*...
0
votes
0answers
742 views

Understanding the time difference between data grid initial display and export/full display using Toad for Oracle

I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...
3
votes
1answer
3k views

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 ...
3
votes
1answer
140 views

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 ...
1
vote
1answer
42k views

Connecting to database using Toad in windows

I am trying to connect to a database using Toad on windows 7. But I am not able to connect because I dont have SQLNET Editor, TNSNames Editor and LDAP Editor installed. Please help me with this. I ...
1
vote
0answers
587 views

Oracle TOAD and Team Coding with TFS: Unable to get revisions from TFS

My company is currently exploring the option of using TOAD as a means to seamlessly allow developers to check-in/check-out code in TFS. This would be seeded by our packages, stored procedures, etc. ...
0
votes
1answer
22k views

Exporting MySQL Database into single SQL File in TOAD

Using TOAD, is it possible to export an entire MySQL database to a single file?
6
votes
1answer
2k views

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!
0
votes
2answers
5k views

How to set lower case for identifiers in Toad?

I'm using Toad to write queries agains an Oracle database. When I write table_name. I get an auto-suggestion menu with all the column names. But if I choose a column name, both the table name and ...