Top "Toad" questions

Testing DB Link - ORA-12154: TNS:could not resolve the connect identifier specified

I know there is a load of times this question has been asked but I can't quite figure out how …

database oracle oracle10g toad dblink

Oracle Execution Plan

I am using Oracle 11g and Toad for Oracle. How can I display execution plan for queries? In Sql server …

oracle toad sql-execution-plan

How do I generate a script of all database objects in Toad for MySQL

In the freeware version of Toad for MySQL (latest version), I can generate a script of all tables in my …

mysql database-schema toad sql-scripts

Can't initialize OCI. Error -1. Toad for Oracle 10 and Oracle 10g

I am trying to connect Oracle 10g database server from my client PC using toad 10 Commercial. I have Oracle 10g …

oracle10g toad

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 …

sql oracle toad

Debugging PLSQL in Toad

I've been creating packages for Oracle db using PL/SQL and i'm trying to find a good way to debug …

plsql toad

ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I …

oracle plsql toad database-cursor ora-00932

Why can't I see Tables/Sequences in Toad's Schema Browser?

Using Toad 9.7.2 against a network Oracle DB (10g) I can't see any objects in the schema browser using the account …

oracle privileges toad

ORA-01735: invalid ALTER TABLE option - Toad

When i execute below SQL in Toad its throws "ORA-01735: invalid ALTER TABLE option". ALTER TABLE CALCULATE ADD (CAL_METHOD …

sql oracle toad

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 …

toad