stews

Member since 09/17/2008

4 snippets

1743 profile views

0 Comment(s) Posted

View their favorites

their Tags

update Oracle table query

Profile

Achievement

stews's Recent Snippets

All /

« Prev 1 Next »

PL/SQL Function to get first record from query and return single value

Nothing amazing here, just an efficient way to get the first row. Be sure to set your ORDER BY clause properly.

query

0 1230 posted 16 years ago by stews

PL/SQL Record Exists function template

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?

table

0 1090 posted 16 years ago by stews

PL/SQL Efficiently compare columns from two tables

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...

Oracle

0 1230 posted 16 years ago by stews

PL/SQL UPDATE using WHERE CURRENT OF clause

I can never remember the syntax on the "FOR UPDATE OF" clause!

update

0 905 posted 16 years ago by stews