Reputation
212
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 11
Newest
 Yearling
Impact
~6k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Jan
29
accepted Select max(pk) instead of sequence.nextval
Jan
19
awarded  Yearling
Jan
18
comment Is introducing a where condition into the join clause bad practice
As for your link, is there any way I can read it without registering on that website? I'm sorry to ask you this but I don't see any close button on the modal popup.
Jan
18
accepted Is introducing a where condition into the join clause bad practice
Jan
18
asked Is introducing a where condition into the join clause bad practice
Dec
24
accepted Does an order by clause have a negative effect on performance?
Dec
24
awarded  Curious
Dec
23
asked Does an order by clause have a negative effect on performance?
Dec
9
comment Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?
One of the best answers I've received in all the SE sites. Thank you for your elaborate answer and the references. A big one upvote !
Dec
9
accepted Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?
Dec
8
comment Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?
@ToddEverett I've updated my post. Thank you.
Dec
8
revised Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?
added 40 characters in body
Dec
8
revised Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?
added 40 characters in body
Dec
8
asked Is splitting a CSV column into a separate table(enforcing 1nf) unnecessary complication?
Dec
7
accepted What adverse effects does a table have when it's not even in 1nf?
Dec
7
asked What adverse effects does a table have when it's not even in 1nf?
Dec
7
accepted Can I use the cost of a query to prove its efficiency when there is only a small number of rows?
Dec
7
accepted Chance of duplicate on single select max into statement
Dec
7
comment Chance of duplicate on single select max into statement
Sorry to bother you but I wanted to make it extra clear. So nesting a select max() within the insert statement does not eliminate the chance of duplicate values ? I ask you this because my superior specifically told me to do that because he said this(nesting select max() within insert) will eliminate duplicate values or give less chance of multiple sessions mixed over because of little time between select max() and insert.
Dec
7
comment Chance of duplicate on single select max into statement
Using a sequence will be indeed my preference. However, in my specific case, that could cause some issue with the code along with bothering all the other devs to change their code. Do you have any knowledge regarding my question #1 ?