• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Update In Oracle Question

MobileCheese

More time posting than coding
Joined
Apr 30, 2006
Messages
265
Likes received
0
Thanks received
0
Sorted now mods please delete
 
Last edited: 21:47
MobileCheese said:
Sorted now mods please delete
We no how do Sorted delete mods in Oracle.

Very quick us software engineer do Oracle cheap.
 
MobileCheese said:
Sorted now mods please delete
Seriously, isn't that a little self-centred? Please leave the question here, and post the solution too. That is how Usenet and Bulletin Boards became a reserve of knowledge.

Not to be too rude, but deleting the question because you have the answer is a little like those who post a question and add "please reply by e-mail because I rarely read these discussions". If you use it, contribute too; they also contribute who ask, as well as who answer.
 
I deleted the post because it was relatively stupied question and I got the answer somewhere else, I also thought after CUK wasnt a good place to post it.

If you interested though, I was questioning what the correct behaviour for the following UPDATE statement was,

UPDATE TABLE1 a
SET a.JOB = (select b.job from temp b where a.id = b.id)

I assumed it would only update where the join condition of a.id = b.id was met but it appears not. Anything that didnt meet that condition was updated to NULL anything that did meet that condition was updated to the value in the temp table. It was late on Friday and I wasnt sure if that was the correct behaviour or somewhere along the line I hadnt been commiting my changes.

Anyway the answer was it was correctly nulling stuff where the join conidtion wasnt meet. To fix this I need to add a WHERE statement witn EXSITS IN.

The END 'Test Post Please'

Thanks :D
 
Last edited: 12:46
Nothing to add really. Just fancied getting the last post in every section sad boy award.
 
He he....

Was trying to find a post to post in to get the same. Was going to post in the Exporting JDA somesuch or other and though "nah, looks too technical" so went for this thread and sparticus beat me to it.... moff to LR!
 
MobileCheese said:
I deleted the post because it was relatively stupid question and I got the answer somewhere else, I also thought after CUK wasnt a good place to post it.
Thanks for re-posting. Of course, it was elementary, not stupid :) It's a mistake that I've made too: maybe your post will save someone else from making it.

You may well be right that CUK is not the place to post serious questions, nor to remove what you think is stupid.
 

Advertisers

Back
Top