Tool for Oracle Application Developers

learn more… | top users | synonyms

0
votes
0answers
21 views

Toad Error using Proxy Connection

I created a login for a user two days ago to an oracle database and altered another user so this new user could do a proxy connection as that user. Everything worked fine that day and the user was ...
0
votes
0answers
82 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 ...
0
votes
0answers
61 views

Connecting to Oracle database installed in one machine using Toad from another machine

I've an Oracle 12c installed in one machine in the LAN, and am able to access this database from the other machines in the LAN by the java applications using the jdbc thin driver connection ...
1
vote
0answers
17 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. ... ...
0
votes
0answers
16 views

How do I setup description_list properly without having invalid username error

I'm running Toad 12.6.0.53 and I'm working on two databases which contain the same setup - but are not clones as the schemanames vary between the two databases. As in 99% of the time it is NOT ...
0
votes
1answer
162 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 ...
0
votes
1answer
409 views

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

How to login as common user in Oracle using Toad?

I have created a common user in Oracle and the pluggable database name is pdborcl. I am able to login as sysdba with the common userid and password but not able to login as a normal user. Can anyone ...
0
votes
0answers
100 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
127 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
49 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
99 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
2k views

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

Hi 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 procedure get executed successfully. What I am doing wrong. ...
1
vote
1answer
5k 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 ...
0
votes
1answer
455 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 ...
1
vote
1answer
497 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 ...
0
votes
1answer
4k 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
2k 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; ...
1
vote
0answers
71 views

Toad for MySQL pauses exactly 2 seconds after executing statement [closed]

Environment: Toad for MySQL 6.3 and MySQL Server 5.6 on Windows 7 Whenever I perform any query, the Editor in Toad pauses for 2 seconds. This happens every time. Example: show tables; (Duration ...
0
votes
0answers
353 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 ...
2
votes
1answer
1k 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
92 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
votes
1answer
2k 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
311 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. ...
-1
votes
1answer
7k 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?
2
votes
1answer
594 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
1k 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 ...