Thought we'd all moved on from that join syntax these days.

Interesting.

Your job sucks... :p

You need to examine the data more, if possible go back to source and get a data dictionary.

It looks like you have 5 or more tables rolled...

yes, that is straightforward, as long as you have a row terminator (eg lfcr)

Unless it is fixed field format - or you insert each row into a (probably single column) staging table and subsequently parse out into your destination tables the values you need,...

Cheers, but thats not it - good luck with yours tho!

aye, thanks, pretty sure this is something different tho. 

This survey is currently closed.

Please contact the author of this survey for further assistance

Brilliance.

After all these years as a dba, finally someone has shown me how to become a power user!

Fantastic, thank you all!

did you flush the cash between each run?

I dont think it matters... does it

its not like we are using oracle 7.3 or something... unless we set some rather technical options.  In...

Yes, I see.

I fail to understand why the default behaviour should alter the underlying data so dramatically tho (cutting off both seconds and milliseconds)?

Surely the sensible default would be the...

can you join to another view?

So whats so extreme about conventions for naming of 'system created constraints'?

It's damnably hard work to issue database upgrade scripts from Dev --> QA --> Live without having standard, explicit...

Pretty sure he's talking about the article making its way onto such a well run, professional site.

Forgive me if im mistaken...

Yes, it is possible - the tran that caused me problems could easily have stayed open for weeks if we hadn't been monitoring the situation!  As it was we caught...