Ben Brumm
  • Male
  • Geelong, Victoria
  • Australia
Share on Facebook
Share

Gifts Received

Gift

Ben Brumm has not received any gifts yet

Give a Gift

 

Ben Brumm's Page

Latest Activity

Ben Brumm posted a blog post

4 Things to Know About the GREATEST Function in Oracle

The GREATEST function in Oracle is one that is helpful, but I haven't seen used very often. If you do use it, keep these things in mind.What Is The GREATEST Function?The first thing to know about the function is what it does.GREATEST finds the greatest value in a list of provided values.The syntax is:GREATEST ( expr1, [ expr_n] )You provide it with a set of expressions, and the function will find the greatest of these.It's Not an Aggregate FunctionUnlike the MAX function,…See More
Nov 27, 2016
Ben Brumm posted a blog post

How To Use SQL Aggregate Functions as Analytic Functions

Many functions in Oracle SQL are commonly used as aggregate functions, but can also be used as analytic functions. I'll explain what this means and how to do it in this article. What is an analytic function? In Oracle SQL, an analytic function is a function that allows you to perform a calculation on a subset of rows. Normally, the function is performed on all rows, but some functions allow you to perform the calculation on a subset or subgroup of rows. Why would you want to do this? Perhaps…See More
Nov 14, 2016
Ben Brumm is now a member of Oracle Community
Nov 2, 2016

Profile Information

About Me:
Database developer and software consultant, have been working in the industry for about 10 years.
My Blog:
http://www.databasestar.com
My Website:
http://www.databasestar.com

Ben Brumm's Blog

4 Things to Know About the GREATEST Function in Oracle

The GREATEST function in Oracle is one that is helpful, but I haven't seen used very often. If you do use it, keep these things in mind.
What Is The GREATEST Function?
The first thing to know about the function is what it does.
GREATEST finds the greatest value in a list of provided values.
The syntax is:
GREATEST ( expr1, [ expr_n] )
You provide it with a set of expressions, and the function will find the greatest of…
Continue

Posted on November 27, 2016 at 10:00am

How To Use SQL Aggregate Functions as Analytic Functions

Many functions in Oracle SQL are commonly used as aggregate functions, but can also be used as analytic functions. I'll explain what this means and how to do it in this article.
 
What is an analytic function?
 
In Oracle SQL, an analytic function is a function that allows you to perform a calculation on a subset of rows. Normally, the function is performed on all rows, but some functions allow you to perform the calculation on a subset or…
Continue

Posted on November 14, 2016 at 10:34am

Comment Wall

You need to be a member of Oracle Community to add comments!

Join Oracle Community

  • No comments yet!
 
 
 

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…

Continue

Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…

Continue

Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…

Continue

Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…

Continue

Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service