O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CRITICAL SKILL 2.6

Employ Functions: String, Numeric, Aggregate (No Grouping)

Up to now, we have illustrated a number of fairly simplistic DML statements. We’ve selected some records from different tables using criteria, we’ve updated existing rows, and we’ve even inserted and deleted some records.

Oracle provides us with many functions that allow us to analyze and aggregate the data, returning results that differ greatly from the result sets we’ve seen so far. A function manipulates the contents of a column in a SQL statement. We can find what the largest credit limit is in the CUSTOMERS table, we can round numbers or pad results with characters. In fact, when we ran a count of customers that were in the province of ‘Delhi’ before and after ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required