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

Suntec’s Data Mining Services Help You Get Efficient Data

It is a well- established fact that the availability of accurate and updated data is the base of undertaking successful business operations. Data is required at all point of business operations ranging from buying of goods and services from suppliers to marketing your final product. Often, business organizations fail to utilize their data to its full potential.

At SunTec, our…

Continue

Posted by Alvaro Dee on May 26, 2017 at 3:46am

Convert Prospects into Repeat Customers with Amazon Data Entry Services

eCommerce store owners get a better exposure for their products by selling on a platform like Amazon. If you are thinking about selling on Amazon or you are already a seller who needs help in managing product listings on this popular online marketplace, stop worrying. Professionals with sound technical knowledge of Amazon product listings, categorization, content, etc. are there to make things easier for you.

You can outsource …

Continue

Posted by Alvaro Dee on April 12, 2017 at 10:05pm

Increase Sales with Unique and Compelling Product Descriptions

Are you thinking about opening an online store? Or, do you already have one? Whether you have a small online business or a big store, the manner in which you list your products leads to a dramatic impact on your sales.



Don’t just sell a product, you need to sell an experience.
You yourself get excited about the features and specifications of your products. But the problem is that your…

Continue

Posted by Alvaro Dee on April 10, 2017 at 11:18pm

Business Research Helps You Understand Critical Traits of Your Business

Business organization needs strong customer and actionable industry insights to develop better understanding of its market and other important aspects. It can meet business objectives and make tactical, strategic and operational decisions with the help of business research services. The growth of a company largely depends on effective business research. You can conduct a successful market research with…

Continue

Posted by Alvaro Dee on April 3, 2017 at 3:23am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service