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
-2
votes
1 answer

ORA-08102: index key not found, obj# 194450, file 51, block 10623 (2) ORA-02063: preceding line from LIVEPAY

I ran a delete query in asp.net c# but it gives following error ORA-08102: index key not found, obj# 194450, file 51, block 10623 (2) ORA-02063: preceding line from LIVEPAY but ran the query on toad it works fine on toad. any help will be highly…
abdulrub abbasi
  • 1
  • 2
-2
votes
1 answer

Build a query in Oracle 11g with rownum in output

I have a scenario and build a Oracle query for it. Table Columns: Plan_No, Invoice_No,Order_Dt. One plan will have more than one invoice. I want get this output: Plan_No Invoice_No Order_Dt Row_No A1 1001 23-May-17 1 A1 1002 …
Murtuza Badshah
  • 1
  • 2
-2
votes
1 answer

loop through cursor's data and compare for another table's value sql

I have two tables. I want to get desc from Table 2 after following steps: 1. Select name from Table1 where type = 'animal'; 2. loop through each names from 1. and check for Table2 i.e o_name = name; 3. Then check if desc exist for that o_name. 4. If…
Rthp
  • 85
  • 1
  • 13
-2
votes
1 answer

Execute Mysql queries using the same file more than once

I have a file with .sql extension in which I write a query like insertions, deletions or updates, and execute it in toadformysql . I repeat the same action many times because I have lot of queries, so it turned out that I have a lot .sql files. for…
zinzin
  • 1
  • 2
-2
votes
1 answer

waiting for long time when set save point in toad for sql server editor and executed from java?

I set the save point in toad for sql server like below begin tran clck1 save tran p1 delete from table_name where s_no>100; Then i started running java program to take remaining data from table_name and to do process. But java waiting for long time…
Raj
  • 677
  • 3
  • 8
  • 16
-2
votes
1 answer

How to get combined output from a inner subquery?

My Output: A B C D E F 773 26 429 150000 500000 800000 773 26 117 150000 500000 800000 808 26 26 150000 500000 800000 809 26 26 150000 500000 800000 Need Output like below: A B C D E F 773 26 429 150000 …
Stephen L
  • 351
  • 2
  • 6
  • 18
-2
votes
1 answer

how to Combine two tables column in oracle?

Table 1: CURRENCY CODE ER GUARANTOR ID G AMOUNT USD 1.2986 117 750 AED 4.76976 117 5750 ZAR 11.4717 117 234 INR 70.676 117 1243 AMD 526.5823 117 500000 EUR …
Stephen L
  • 351
  • 2
  • 6
  • 18
-3
votes
1 answer

Getting syntax error on SQL but i know the syntax should be right

Toad Syntax error ALTER TABLE db_group ADD COLUMN IF NOT EXISTS `isPublic` tinyint(4) not null default 0; ALTER TABLE db_group_point MODIFY COLUMN group_code varchar(50) NOT NULL DEFAULT 0 COLLATE utf8_bin; -- ALTER TABLE db_group_point DROP…
Junk Man
  • 1
  • 1
-3
votes
1 answer

Joining two tables with common primary key but bring in additional columns that is causing cartesian

I'm trying to join two tables similar to below. Is it possible to even join and get data without cartesian products? Would appreciate any help, Thanks! Table 1 : Primary Key Column : Field2 : R1 : C1 : R1 : C2 : R2 …
Cindy
  • 133
  • 1
  • 5
  • 13
-3
votes
1 answer

Unable to execute procedure and package

I'm unable to execute procedures and packages in TOAD. Could anybody please help me out. How to execute the procedure and packages Give me some key points
manikanta
  • 1
  • 1
-3
votes
1 answer

My pl sql block is executing for only 15 min i need to increase the execution time in toad

I need to increase PL/SQL Block execution time more than 15 min in toad. Is there any settings in toad means suggest me ?
Ramesh T
  • 1
  • 1
-3
votes
2 answers

DBMS_OUTPUT.PUT_LINE doesn't print with output and pooling turned on

DBMS_OUTPUT.PUT_LINE( ) doesn't print output however output and spooling are turned on. "Procedure is completed successfully" message is displayed without any output. When run in SQLPLUS it throws errors. Do you have any idea to check? I tried the…
Willy
  • 45
  • 1
  • 8
-3
votes
2 answers

Backup of procedures in toad oracle 12.1?

Procedure for taking backup of procedures in toad oracle 12.1? I would also like to ask the difference between procedures and stored procedures
SRINIVAS SANTHOSH
  • 1
  • 4
-3
votes
1 answer

Free or trial Oracle database environment

What is the best free (or trial) Oracle database development environment I can have? Especially I would like to have my databases, or as much as possible of them, locally. Its Oracle 10, I develop .NET (on Windows), I already have Toad and the free…
user1372174
  • 17
  • 1
  • 1
-4
votes
1 answer

Return a User Defined Table From a Query Plus Hardcoded Variable in PL/SQL

I have the following scenario: I need to feed into either a Procedure or Function the Following Parameters: Link_1_ID, Link_2_ID, Address1, Address2, City, State, Zip, Address_Type These will be used to query a table (we'll call the Table…
JoeS.
  • 73
  • 6
1 2 3
…
84
85