bbrumm

Member since 11/30/2016

Name: Ben Brumm

Location: Melbourne

A software consultant, based in Melbourne with 10 years experience in a range of roles and technologies including Oracle SQL and business analysis.

103 snippets

3807 profile views

0 Comment(s) Posted

View their favorites

their Tags

sql Oracle

Profile

Achievement

bbrumm's Recent Snippets

All /

« Prev 1 2 3 4 Next »

SQL Oracle DENSE_RANK Function

A few examples of the DENSE_RANK function.

Oracle
sql

0 734 posted 7 years ago by bbrumm

SQL Oracle SYSTIMESTAMP Function

A few examples of the SYSTIMESTAMP function.

Oracle
sql

0 662 posted 7 years ago by bbrumm

SQL Oracle SQLERRM Function

An example of the Oracle SQLERRM function

Oracle
sql

0 716 posted 7 years ago by bbrumm

SQL Oracle SYS_CONTEXT Function

A few examples of the SYS_CONTEXT function.

Oracle
sql

0 663 posted 7 years ago by bbrumm

SQL Oracle LOG Function

A few examples of the Oracle LOG function.

Oracle
sql

0 676 posted 7 years ago by bbrumm

SQL Oracle LAST_DAY Function

A few examples of the Oracle LAST_DAY function.

Oracle
sql

0 705 posted 7 years ago by bbrumm

SQL Oracle FLOOR Function

A few examples of the Oracle FLOOR function.

Oracle
sql

0 681 posted 7 years ago by bbrumm

SQL Oracle MOD Function

A few examples of the MOD function.

Oracle
sql

0 623 posted 7 years ago by bbrumm

SQL Oracle NULLIF Function

A few examples of the NULLIF function.

Oracle
sql

0 645 posted 7 years ago by bbrumm

SQL Oracle REMAINDER Function

A few examples of the REMAINDER function in Oracle.

Oracle
sql

0 721 posted 7 years ago by bbrumm

SQL Oracle TO_TIMESTAMP_TZ Function

A few examples of the TO_TIMESTAMP_TZ function.

Oracle
sql

0 751 posted 7 years ago by bbrumm

SQL Oracle ADD_MONTHS Function

A few examples of the ADD_MONTHS function

Oracle
sql

0 757 posted 7 years ago by bbrumm

SQL Oracle COALESCE Function

A few examples of the Oracle COALESCE function.

Oracle
sql

0 752 posted 7 years ago by bbrumm

SQL Oracle UPPER Function

A few examples of the UPPER function.

Oracle
sql

0 817 posted 7 years ago by bbrumm

SQL Oracle CAST Function

A few examples of the Oracle CAST function.

Oracle
sql

0 755 posted 7 years ago by bbrumm

SQL Oracle LPAD Function

A few examples of the Oracle LPAD function.

Oracle
sql

0 646 posted 7 years ago by bbrumm

SQL Oracle TRUNC Function

A few examples of the Oracle TRUNC function.

Oracle
sql

0 800 posted 7 years ago by bbrumm

SQL Oracle MONTHS_BETWEEN Function

A few examples of the MONTHS_BETWEEN function.

Oracle
sql

0 676 posted 7 years ago by bbrumm

SQL Oracle TRIM Function

A few examples of the TRIM function.

Oracle
sql

0 741 posted 7 years ago by bbrumm

SQL Oracle DECODE Function

A few examples of the Oracle DECODE function

Oracle
sql

0 764 posted 7 years ago by bbrumm

SQL Oracle ROUND Function

A few examples of the Oracle ROUND function.

Oracle
sql

0 978 posted 7 years ago by bbrumm

SQL Oracle DECODE Function

A few examples of the DECODE function.

Oracle
sql

0 702 posted 7 years ago by bbrumm

SQL Oracle SUBSTR Function

A few examples of the Oracle SUBSTR function.

Oracle
sql

0 703 posted 7 years ago by bbrumm

SQL Oracle TO_TIMESTAMP Function

A few examples of the Oracle TO_TIMESTAMP function.

Oracle
sql

0 661 posted 7 years ago by bbrumm

SQL Oracle NVL Function

A few examples of the Oracle NVL function with some sample data.

Oracle
sql

0 975 posted 7 years ago by bbrumm

SQL Oracle CHR Function

A few examples of the Oracle CHR function.

Oracle
sql

0 633 posted 7 years ago by bbrumm

SQL Oracle CEIL Function

A few examples of the Oracle CEIL function.

Oracle
sql

0 695 posted 7 years ago by bbrumm

SQL Oracle EXP Function

A few examples of the EXP function.

Oracle
sql

0 859 posted 7 years ago by bbrumm

SQL Oracle TO_NUMBER Function

A few examples of the TO_NUMBER function

Oracle
sql

0 888 posted 7 years ago by bbrumm

SQL Oracle RPAD Function

A few examples of the Oracle RPAD function, with some tables being set up.

Oracle
sql