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 ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
