Search results for query: *

HEY!!!! It just worked. Awesome. Thanks for the responses. Cheers.

Thanks for the quick response. I added the following entry to cron, to run every 5 minutes but it didn't change the permissions in the directory (I actually had a prefix that I added in for specific files to change). I'm sure there's some small detail that I've missed. I haven't used the cron...

I read through many of the threads so as to avoid redundancy, so if this is somewhere else please excuse my ignorance. I need to chmod every file that enters a directory so it is globally writable. Do I need to set up a cron for this? Is there a way to set up the directory so every file is...

I would be really careful using the native Import function on TOAD. It's very slow for any kind of sizeable data. If anything, you'll want to use the DBA/SQLLOADERWIZARD in TOAD, which just creates a sql loader script. It's slightly easier since it will build it for you. If you need to do...

It might be useful to check your column sizes for these datatypes if they're of the Varchar variety. If you've got leading or trailing spaces you'll need to trim() them. Id's can be tricky that way. You're getting the 12490 rows returned because it doesn't have that key piece of data, being...

Ok, thanks Mufasa, I just got finished talking him into doing it your way. Thanks for your help and have a great 2005. -G

What we have is data that is generated here, sent to another company, revised for accuracy and sent back. Then we compare what changed with teh new vs. the old. Neither one is more important. Just the Delta so we know what is in error and what is not. What they plan on doing is looking at...

That should say "return a row for each change" not "column. -G

Happy new year Dave! I am expecting no more than . . .5 changes per row. I have already paired down my tables to ~144K rows combined, which is a start. The business need is, the boss says "I want the differences between these tables, and only the differences." So I create a script that does...

Wow that's awesome Dave. Only one glitch in that. If I return a row for every change on 1.3 million rows, I'm going to have a hell of a table! Im thinking I can return those values into fields in rows rather than columns? What do you think? -G

I have two tables with same %rowtype. They're about 1.3 million rows each. I want to return into a third table the column name, and the data that is different (comparison). I don't want to have to loop through each column on each table so I created a minus scenario that returns rows on each...

Thanks for your assistance on this guys. I haven't had a chance to run it, I got sidetracked on another project. As soon as I know if it works I'll let you know.

Ok! Sorry for being such a rookie guys. There are three header rows followed by a space. Everything is marked and numbered. As you may or may not be able to tell, line 9 doesn't line up with the rest of the rows. Thanks a million. Header H H Space 1 CLIENT XXX XXX: XXXXXXX...

Gotcha. I have a cleaned up version, but the font is coming out too large for this screen. there doesn't seem to be any size tags for the tgml. Suggestions?

I'm not quite sure I understand what that does, especially the fpos function. I ran it exactly the way you posted it, just to see what the output was and modify from there. I changed what appear the be the positional parameters "fpos "1 15. . ." and it seems to repeat the first word from the...

Sorry, Desired output is columnar: Name Address City State data data data data futurelet, I will give that a go! Thank you.

I have a report that I am beating my head against a wall about to get parsed correctly. I has variable length data after colons and the data is in blocks. Name: John Addr1: x way PBL: Y ON CD: N Exp DATE: 000000 Enr Date: 000000 Ded Dtn: 40402 Addr2: LNAME...