stews


Member since 09/17/2008

4 snippets

1211 profile views

0 Comment(s) Posted

View their favorites

their Tags


Profile

Achievement

first submission:submitting first snipplet

stews's Recent Snippets



« Prev 1 Next »
Nothing amazing here, just an efficient way to get the first row. Be sure to set your ORDER BY clause properly.
0 976 posted 15 years ago by stews
I often need to know if a record exists in a table. This method is probably the most efficient. Too many people don't use the exceptions that Oracle provides, which is a shame. I think I got it from Tom Kyte's site? Or Steven Feuerstein?
0 785 posted 15 years ago by stews
This compares selected columns between 2 tables that you think might have differences. It lists the rows and values that are different between the two sources You can add WHERE clauses as appropriate. You could also use this to compare the resul...
0 942 posted 15 years ago by stews
I can never remember the syntax on the "FOR UPDATE OF" clause!
0 641 posted 15 years ago by stews
« Prev 1 Next »