Toad World® Forums

'Compare files' utility

I frequently use the ‘compare files’ utility to compare code such as sql and also .txt files which often contain data.

.

I often notice that my data files seem to have rows repeated, for example, I produced a data file today to compare to one from yesterday. The files both had about the same number of rows, 2431, and are in the same sequence. However, the compare showed a row count of 3495.

.

What is causing some of the rows to appear more than once?

.

I did a clean install on a new computer recently so there should be no leftover settings or anythign else affecting the program.

Paul

I don’t know but if you can send me your files I’ll take a look. You can send to john.dorlon@quest.com.

John, I would have to duplicate the problem with different data. The current files are full of confidential data (ssn, name, dob). Could I just attach in a future reply?

Sure. Please don’t send me real SSNs. I don’t want that kind of responsibility! You can block select them in the Editor and type over them all at the same time.

Hello,

I am trying to cancel a query from toad which is getting executed with db link. Generally when I press escape key query cancel but whith dblink query it is not cancelling .is there a way to cancel query right away? Please advise ?

Your help is appreciated .

Thanks

Sreenivas

On Dec 2, 2015 4:58 PM, “John Dorlon” bounce-jdorlon@toadworld.com wrote:

RE: ‘Compare files’ utility

Reply by John Dorlon
Sure. Please don’t send me real SSNs. I don’t want that kind of responsibility! You can block select them in the Editor and type over them all at the same time.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Sreenivas,

We send the cancel command to Oracle but sometimes it takes time for Oracle to respond.

Please, in the future, start a separate thread rather than adding your question to an existing thread.

-John